Category Archives: Cool stuff

Backups are forever

You should save this link in your bookmarks, for the next time you accidentally remove your database’s online redologs or overwrite some ASM disks: http://www.youtube.com/watch?v=Q-dELw73Z94&feature=player_embedded   NB! I am running one more Advanced Oracle Troubleshooting training in 2018! You can … Continue reading

Posted in Cool stuff | 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: https://github.com/oracle-developer/moats 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 Enkitec.tv 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