oracle: how to create directory and grant permissions to users
Create & grant permission to directory in Oracle Create directory in …
oracle: how to create directory and grant permissions to users Read More »
oracle dba
ORA-00020 maximum number of processes exceeded
ORA-00020 maximum number of processes exceededCause: All process state objects are …
How to enable the Fast Recovery Area in Oracle 12c
If you haven’t already done so, enabling your system to …
How to enable the Fast Recovery Area in Oracle 12c Read More »
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′
After incomplete recovery of my one of the database, I …
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′ Read More »
Useful sql scripts for Oracle DBA
Note: These scripts runs with SYSDBA privileges cpu_usage.sql – Show …