Scripts and Tools used at Tanel's Oracle Troubleshooting seminars
You can download most of the scripts Tanel uses from the .zip file below.
- Unix/Mac: tpt_public_unixmac
- Windows: tpt_public_win.zip
- Demos are in demos, aot and ast directories
- The command I use for running rlwrap (for getting command line history and completion) is stored in the setup/README_rlwrap.txt file in tpt_public.zip
Visualize Statspack, AWR data (and any other SQL result-set) in Excel
Related articles by topic
Introduction & Systematic Troubleshooting
Physical IO, DBWR & NUMA
Oracle SGA and OS Memory
Enqueue Locks & Deadlocks
Hangs & Crashes
Note that there are some links and MOS notes in my old seminar link page too, I will move them here later too!