Nothing but my learning and experience with Oracle..!

Rman incremental backup and restore an example its a simple demonstration of rman incremental backup and restore , any oracle enthusiast ...

A script to check RAC log switch  The following script reports how much time passed between log switches in a time period. SELECT C.IN...

The important of enabling autobackup in rman  BY enabling few default parameters of RMAN will save the life of dba significantly. RMAN h...

Index skip scan in oracle With Oracle 9i, CBO is equipped with many more features, one of them is “Index skip scan” .This means even if...

Avoid Sorting done by 'ORDER BY' clause TASTCASE 1: Step1:  Create a table EMP as SQL> conn mahi/mahi Connected. SQL> CREA...