Oracle Diagnostics

Ċ ExplainPlan_SG_RACSIG_12Oct11.pdf
View Download
30-45minute presentation during Singapore RACSIG meeting on 12-Oct-11.  414k v. 1 Oct 13, 2011, 8:16 AM Hemant K Chitale
Ċ Incomplete_Recovery_with_BackupControlfile.pdf
View Download
Incomplete Recovery with a Backup Controlfile (in 10.2)  383k v. 1 Feb 13, 2011, 7:35 AM Hemant K Chitale
Ċ Insert_Lock_Holder_Waiter.pdf
View Download
A demonstration of an INSERT statement waiting on a lock   194k v. 2 Jun 9, 2012, 8:27 PM Hemant K Chitale
Ċ MyOracleBlogBackup_and_RecoveryPosts.pdf
View Download
This is a collection of my Oracle Blog posts on Backup and Recovery, Control files, ArchiveLogs and such. These go as far back as December 2006 and are current as of upto 03-May-2011. I have also included comments as of upto 03-May-2011.   1049k v. 1 May 4, 2011, 7:45 AM Hemant K Chitale
Ċ Oracle Database Performance Diagnostics -- before your begin.pdf
View Download
How to begin with Performance Diagnostics in an Oracle Database environment.  307k v. 2 Mar 10, 2012, 6:48 AM Hemant K Chitale
Ċ Oracle_Database_Performance_Diagnostics.pdf
View Download
Oracle Database "Performance" -- A Diagnostics Method Copy of Presentation made at BrainSurface – Virtathon 20-July-2011   1210k v. 1 Jul 20, 2011, 8:00 AM Hemant K Chitale
Ċ OracleDiagnostics_Explain_Plans__simple.pdf
View Download
A simple introduction to Explain Plan in Oracle, using the DBMS_XPLAN procedures.  175k v. 1 Apr 21, 2011, 9:34 AM Hemant K Chitale
Ċ OracleDiagnostics_Joins__1.pdf
View Download
Following my previous presentation on reading a simple Explain Plan, this one covers the two basic join methods : Nested Loop and Hash Join. The Optimizer has to choose between the join methods based on the expected number of rows being accessed and filtered and the cost for each method of access.  143k v. 1 Jun 5, 2011, 8:46 AM Hemant K Chitale
Ċ OracleDiagnostics_Latches_and_Enqueues.pdf
View Download
Latches and Enqueues  137k v. 1 Feb 13, 2011, 7:35 AM Hemant K Chitale
Ċ OracleDiagnosticsLocks_and_LockTrees.pdf
View Download
Locks and LockTrees  123k v. 1 Feb 13, 2011, 7:35 AM Hemant K Chitale
Ċ SQLinFunctions.pdf
View Download
On the usage of SQL in Functions. Why it is not a good idea to put SQL in a Function that may be called very frequently (e.g. for multiple rows in a SELECT).  284k v. 1 Jan 19, 2012, 7:32 AM Hemant K Chitale
Comments