Thursday, October 18, 2012

Temporary Tablespace Related Scripts

›
To check instance-wise total allocated, total used TEMP for both rac and non-rac set lines 152 col FreeSpaceGB format 999.999 col U...

Blocking Session Lockwait Best

›
SELECT TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' User ' ||s1.username || '@' || s1.machine || ' ( SID= ...
Tuesday, September 25, 2012

expdp procedure in 11g

›
 1) create directory export_auto as 'd:\expdp1213';  create user dba_export_user identified by test123; grant connect, create d...
Friday, September 21, 2012

RMAN Block Media Recovery

›
From Oracle 9i onwards you can use RMAN to recover only blocks while database is up and running. This could possibly save hours and hours ...
Thursday, September 20, 2012

Table level Recovery using Flashback Table

›
---------------------------------------------------Recover Dropped Table from Recyclebin using Flashback Table------------------------- ...
Friday, September 14, 2012

11g Active Data Guard - enabling Real-Time Query

›
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo log...

RMAN Recovery Scenarios

›
RMAN Backup and Recovery Scenarios RMAN Backup and Recovery Scenarios   Complete Closed Database Recovery. System tablespace is...

RMAN scenarios

›
http://itcareershift.com/blog1/2010/11/25/real-life-oracle-dba-scenarios-using-rman-backups-and-troubleshooting-new-oracle-dba-career/ htt...