Category Archives: Cool stuff

Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking

If you work with SQL Trace files (and profile them) then you should check out the awesome novel use of the “external table preprocessor” feature explained by Adrian Billington here: Ironically just a day after writing my “Evil things” … Continue reading

Posted in Cool stuff, Oracle | Tagged | 2 Comments

Latch contention troubleshooting case study and Flashback Database performance issues with LOBs

Steve Bamber has written up a case study of library cache latch contention troubleshooting of an Apex application with LatchProf. I’m happy that others also see the value and have had success with my new LatchProf based latch contention troubleshooting … Continue reading

Posted in Cool stuff, Oracle | Tagged , , | 1 Comment

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: MOATS 2.0 … Continue reading

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

ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!

Note that the live event is over by now, but you can see the recording from On Tuesday 22nd March I’ll hold two (yes two) Secret Oracle Hacking Sessions – about ORA-04031: unable to allocate x bytes of shared … Continue reading

Posted in Announcement, Cool stuff, Oracle | Tagged , , , , , , , | 17 Comments