Sunday, March 22, 2015

Performance Tuning: My notes on SQL Plan Management (SPM) --Moid

Posted by at No comments:

Thursday, March 19, 2015

Kill sessios - How to schedule a cronjob to identify and kill oracle session running over 4 hours. --Moid

Posted by at No comments:

Wednesday, March 18, 2015

My notes on Oracle Sorts (order by) --Moid

Posted by at No comments:

MIITDocID-900: How to get Oracle Tablespace Usage History? --Moid

Posted by at No comments:

My queries on Oracle Performance Tuning --Moid

Posted by at No comments:

Wednesday, March 11, 2015

How to check Oracle listener's trace level and turn if off? --Moid

Posted by at No comments:

MIITDocID-995: My notes on Oracle RAC Commands --Moid

Posted by at No comments:

Tuesday, March 10, 2015

RMAN: How to unregister database from RMAN catalog? --Faisal Hasan

Posted by at No comments:

Monday, March 9, 2015

MoidIITDocID-559: How to check the status of Data Pump export? --Moid

Posted by at No comments:

MoidIITDocID-592: My notes on Oracle RAC Services --Moid

Posted by at No comments:

Thursday, March 5, 2015

Data Guard: How to remove database from Data Guard Configuration? --Moid

Posted by at No comments:

Tuesday, March 3, 2015

RMAN: Query to find the last RMAN backup’s log? --Moid

Posted by at No comments:

Tuesday, February 24, 2015

How to disable oracle password verification in default profile? --Moid

Posted by at No comments:

How to delete duplicate rows from Oracle Table? --Moid

Posted by at No comments:

Friday, February 13, 2015

MIITDocID-917: How to find the largest / biggest schema (size wise) in Oracle database? --Moid

Posted by at No comments:

Friday, February 6, 2015

How to export (using Data Pump) a schema using parfile? --Moid

Posted by at No comments:

Thursday, January 29, 2015

How to kill all Oracle foreground connections (without any background processes)?

Posted by at No comments:

Friday, January 16, 2015

MoidIITDocID-550: My notes on SCAN listener --Moid

Posted by at No comments:

Friday, January 2, 2015

MIITDocID-886: How to copy / extract a user's Roles and permissions? --Moid

Posted by at No comments:

Friday, December 26, 2014

RMAN: How to automatically purge archivelog using crontab? --Moid

Posted by at No comments:
Subscribe to: Posts (Atom)

Followers