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:   NB! Dates updated: After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting … 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

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