Tag Archives: Administration

MOATS: The Mother of All Tuning Scripts!

Update: Based on the original MOATS built by Adrian Billington and myself, other folks have built cool variations of MOATS (either based on our code or written completely new ones): MOATS (original) by Adrian Billington & Tanel: https://github.com/oracle-developer/moats MOATS 2.0 … Continue reading

Posted in Cool stuff, Oracle, Productivity | Tagged , , , , | 52 Comments

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 , , , | 19 Comments