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 2.0 (RAC-aware) by Sidney Chen: https://github.com/dbsid/moats_rac SQL Dashboard by … 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