Tag Archives: Oracle 11g

VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles

If you’re interested in leading edge database research (as of 2008 :), the VLDB 2008 proceedings are publicly available now. Here are direct links to some Oracle-specific ones: Oracle SecureFiles System Optimizer Plan Change Management: Improved Stability and Performance in … Continue reading

Posted in Oracle | Tagged , , | 2 Comments

Another use case for WaitProf – diagnosing “events in waitclass Other”

I recently diagnosed a performance issue where the “events in waitclass Other” occasionally took significant part of the session’s response time. For example Snapper (which reads wait event data from V$SESSION_EVENT) reported that during measuring 39.9% of the response time … Continue reading

Posted in Oracle | Tagged , , , | 7 Comments