Recent site activity

Copyright

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