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.
  • Downloadable Files
  • 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

    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!
    Subpages (1): Session Snapper