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

    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
    Comments