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.
May 4, 2011, 7:45 AM
Hemant K Chitale
Oracle Database Performance Diagnostics -- before your begin.pdf ViewDownload
How to begin with Performance Diagnostics in an Oracle Database environment.
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.