Administrator
SQL - PL/SQL
- How to get instance name, database status and instance role in Oracle?
- How to modify "sql page size"?
- How to define logic volume for oracle server?
- How to kill session when system could not drop database user?
- How to see database tablespaces?
- How to see database instance information?
- How to see version of database?
- How to see resource limits?
- How to see all tablespace quotas?
- How to see all profiles and assigned limits?
- How to check database link?
- How to configure EM (Enterprose Manager) if has any problem?
- How to delete archive log files until specific time in RMAN?
- How to check/open archieve log in sqlplus?
- Enterprise Manager and OEM Agent commands in Oracle
- How to alter a profile in Oracle?
- How to define new profile in Oracle?
- How to know system date in Oracle?
- How to see last updated (DDL) table object in Oracle?
- How to see PGA size per oracle session?
- How to set SHMMAX value and what is that?
- How to see FRA (Flash Recovery Area) configuration?
- How to add datafile as logic volume (LV) on the tablespace in Linux?
- How to unlock database user account?
- How to define a tablespace in Windows?
- How to run sql query in shell script?
- How to define and drop temporary tablespace?
- How to run .sql file in sqlplus?
- How to connect into RMAN tool in Windows?
- How to clear screen in sqlplus?
- How to set DB ID in RMAN?
- How to see database open-mode information?
- How to see database tablespaces?
- How to resolve "Enterprise Manager Agent status is Unavailable" issue in Linux?
- How to change oracle max connection limits for "maximum connection exceed problem"?
- How to drop a user from database in Oracle?
- How to see the size of users on specific tablespace in Oracle?
- How to login sqlplus on linux command window in Linux?
- How to kill a session with custom procedure?
- How to shutdown Oracle Database Server in Windows OS?
- How to start Oracle Database Server in Windows OS?
- How to remove a job in Oracle?
- How to know DBMS Jobs information in Oracle?
- Windows'da Oracle XE Service ve Listener Başlatma
- Oracle trace ve alert log nedir, nerede bulunur?
- How to know oracle client version with sqlplus?
- Oracle'da HR kullanıcısına nasıl bağlanılır?
- How to know the current connected user in sqlplus?
- How to transfer database file in Windows?
Architecture
Database Versions
ORA Errors and Solutions
SQL Functions
- [ADVICE] Using both of semicolon and slash characters at the same time
- How to select top 10 records in Oracle 11g and 12c?
Tools
- TORA ile veritabanına nasıl bağlanılır?
- [SOLUTION] - TOra "No available connection provider " Error
- [SOLUTION] - TOra "ORA-12154" Error
Total items: 65
Last updated at 2015-05-24 19:53:16
Last updated at 2015-05-24 19:53:16
