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 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.
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).