Tag Archives: Tuning

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 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

Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes?

There was a question in LinkedIn forum about whether Linux Hugepages should be used in Oracle Exadata Database layer, as they aren’t enabled by default during ACS install. I’m putting my answer into this blog entry – apparently LinkedIn forums … Continue reading

Posted in Oracle | Tagged , , , , | 14 Comments