Oracle Diagnostics
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ċ | 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 | |
| Ċ | View Download |
Incomplete Recovery with a Backup Controlfile (in 10.2) | 383k | v. 1 | Feb 13, 2011, 7:35 AM | Hemant K Chitale | |
| Ċ | View Download |
A demonstration of an INSERT statement waiting on a lock | 194k | v. 2 | Jun 9, 2012, 8:27 PM | Hemant K Chitale | |
| Ċ | View Download |
Some (sample) scripts and methods to monitor and diagnose in an Oracle Database when you do not have Oracle Enterprise Manager. (Presentation made at Singapore Oracle Sessions - III, 14-Jul-2015) | 3572k | v. 2 | Aug 30, 2015, 6:49 PM | Hemant K Chitale | |
| Ċ | 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 | |
| Ċ | 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 | |
| Ċ | 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 | |
| Ċ | 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 | |
| Ċ | 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 | |
| Ċ | View Download |
Latches and Enqueues | 137k | v. 1 | Feb 13, 2011, 7:35 AM | Hemant K Chitale | |
| Ċ | View Download |
Locks and LockTrees | 123k | v. 1 | Feb 13, 2011, 7:35 AM | Hemant K Chitale | |
| Ċ | 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 |