Monthly Archives: September 2008

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

Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others

I have written two posts in one, about a performance issue with writes in system tablespace and introduction of a little DTrace stack sampling script. Have you noticed that DML on tables residing in SYSTEM tablespace is slower than tables … Continue reading

Posted in Oracle | Tagged , , , , | 30 Comments