ORACLE @ Work

What is cursor_sharing parameters ? CURSOR_SHARING determines what kind of SQL statements can share the same cursors. What is possible ...

Here are a few useful commands for those who are new to vi. esc :q! Just quit - don't save esc :e! Revert to saved esc :wq Save a...

Sometimes we want to restore full database except a certain tablespace. That is we need to skip a tablespace for restore operation. M...

[oracle@vmora01rh4 ~]$ srvctl config asm -n vmora01rh4 +ASM1 /u01/app/oracle/product/10.2.0/asm [oracle@vmora01rh4 ~]$ srvctl config asm -n...

"How can I verify what version CRS is?". The version of CRS can be higher than the version of database/ASM software. The comma...

Here are some scripts related to Disk I/O, Events, Waits .   Datafile I/O DATAFILE I/O NOTES: ·  File Name - Datafile name ·  Physical Re...

Run this PL/SQL block as SYS. This will create the Directory, grant the required privileges on the Directory and then create the External ...

We can monitor the progress of an undo operation by running the query shown  below: select ses.username , substr(ses.program, 1, 19) comma...

DBNEWID Utility Prior to the introduction of the DBNEWID utility alteration of the internal DBID of an instance was impossible and altera...

Following query would identify the duplicate rows on a table using self join using rowid among duplicates.  For faster execution, this i...

Is it possible to restore Oracle 9.2 RMAN backup with 10.2.0.4 version? Actually, this is possible because RMAN can read from b...