There is a new white paper on OTN called
Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer. I am working on a 9i project which is considering upgrading to 10g (quite possibly the last such in the world) so I think we'll find it useful. Of course, it might also be helpful to people who have already done the upgrade and are experiencing performance problems in their new environment.
Can't help but feel they're a few years late with that paper.
ReplyDeleteMy current client has taken the decision to go from 9i to 11g - happens next month. Should be fun.
I'm jealous. I would like my project to make that leap too.
ReplyDeleteCheers, APC