Forum OpenACS Q&A: Oracle - experiences with 9i and 10g?
So far, what I've found is that people generally find 9i to be stable, though I have seen some reports that it consumes a lot more system resources than 8i did (but not specifically on Linux). 10g, OTOH, seems a little shaky; Oracle has had to withdraw the latest patchset because it was causing problems with CLOBs, and folks generally seem to regard it as being somewhat experimental.
Although going straight to 10g would let me skip an upgrade, I'm more concerned with stability so the extra future upgrade does not bother me.
Any experiences, war stories, rumors, etc out there?
Oralce 9i optimizer is very sensitive and you need to have proper statistics collected on all tables and index to get an optimized performance.
If in case your performance degrades after upgrading to 9i, use the OPTIMIZER_FEATURES_ENABLE parameter to make oracle optimizer behave like the old version.
One of my coworkers is playing a bit with 10g on Linux in his spare time (I think so far just installing it), but it isn't a priority for us, so you'll likely have converted your site and be done long before we really dig into it seriously.
Apparently Oracle's also claiming that it works fine to upgrade a database directly from 8i to 10g, skipping 9i entirely. If true, that should be nice.
Hm, does anyone even know if OpenACS (what version?) is compatible with 10g? And in what version did OpenACS became fully out of the box compatible with Oracle 9i?
Also, FWIW some people feel that the 126.96.36.199 patch is buggy and are recommending sticking with 188.8.131.52. Others say it's fine, so YMMV.