Monthly Archives: February 2010

New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning

The LatchProf and LatchProfX scripts allow you to be more systematic with latch contention troubleshooting and tuning. No more guesswork is needed as these scripts give you exact session IDs and in this version also SQLIDs of the troublemaking applications. … Continue reading

Posted in Cool stuff, Oracle | Tagged , , | 7 Comments

Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!

I have written the first article to the troubleshooting section of my new website tech.E2SN.com: It’s about a very valuable Oracle troubleshooting tool -> ERRORSTACK trace. I cover 4 frequently asked questions there: Reading the current executing SQL statement text … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , | 14 Comments

Oracle Peformance Visualization…

Coskan Gundogar and Karl Arao have written two interesting articles about Oracle performance analysis and visualization, check these out! Coskan’s article: http://coskan.wordpress.com/2010/01/27/working-with-statspack-part-1a-diagnosis/ Karl’s article: http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/ Note that in March I will be releasing PerfSheet v3.0, which will have lots of … Continue reading

Posted in Cool stuff, Oracle | Tagged | 8 Comments