Oracle Scripts and Tools

Scripts and Tools used at Tanel's Oracle Troubleshooting seminars

You can download most of the scripts Tanel uses from the .zip file below.

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

Oracle PGA

Shared Pool

Library Cache

Enqueue Locks & Deadlocks

Latch Contention

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!