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 Oracle 11g
- Closing The Query Processing Loop in Oracle 11g (this one is about adaptive cursor sharing)
Enjoy! :)
That SPM thing is just what the doctor ordered: only been asking for it for 10 years, finally made it to the “bleeding obvious” stage!
Better late than never, I suppose.
Thanks for the notice, Tanel: this will definitely make a change in our schedule to go 11g, making it much more likely to happen next year.
Cheers,
There’s still an interesting thing with the plan stability which I want to test: how well does the plan management work when you do DDL on underlying objects themselves (as opposed to just gathering stats or patching database version.