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

• PerfSheet31.zip

Related articles by topic

Introduction & Systematic Troubleshooting

• Session Snapper

Physical IO, DBWR & NUMA

• • DBWR performance series by Kevin Closson

  • Scaling Oracle8i book by James Morle (free PDF, registration needed, don't be distracted by the "8i" in the title, there's lots of useful OS & hardware info there!) 

Oracle SGA and OS Memory

• Understanding Oracle process memory usage (using process memory matrix script on Solaris)

• How do the buffer cache and shared pool advisors work?

• KGH: NO ACCESS - buffer cache inside shared pool!

• Operating systems are lazy allocating memory (some different SGA allocation scenarios)

• Oracle Dynamic SGA with DISM on Solaris

Oracle PGA

• • Automatic PGA management presentation by Joze Senegacnik

  • Automatic PGA management white-paper and performance measurements by Oracle Corporation for VLDB conference

Shared Pool

• • Understanding Shared Pool Memory Structures by Oracle Corp, OOW 2005 session

Library Cache

• SQL_ID is just a fancy representation of hash value

• Library cache latches gone in Oracle 11g

Enqueue Locks & Deadlocks

• • Unindexed Foreign Keys article by Tom Kyte

  • Diagnosing Locking Problems series by Doug Burns

  • Resolving HW enqueue contention by Riyaj Shamshudeen

Latch Contention

• Using LatchProf and LatchProfX for latch contention troubleshooting

• Cache buffers chains latch contention - a better way for identifying the hot block

• Reliable latch waits in Oracle 10.2+

Hangs & Crashes

• How to read ERRORSTACK output

• How to log on even when SYSDBA can't do so

• The full power of Oracle diagnostic events - part1

  • The full power of Oracle diagnostic events - part2 (11g new improvements)

  • ORADEBUG DOC (explaining new diagnostic event syntax in 11g)

Note that there are some links and MOS notes in my old seminar link page too, I will move them here later too!

• http://blog.tanelpoder.com/seminar/seminar-links/