Sigh, There are many answers to this question related to the environment you will be deploying into. It sounds like you are actually maintaining many databases. Are all of them really 24x7 (i.e. less than a minute of downtime per year) or can you schedule maintenance in the future that will not affect revenues?
Sticking with 9.0.x means having to jump through more hoops in the end and having to live with any issues you have that you cannot address. 9.2 is really more like 9.0.2 with some features bolted on (closer to 8.0.5 in my opinion). You'll have a MUCH easier time getting issues addressed with 9.2 over the long haul (> 8 months). But if you are in a true 24x7 shop, and you have an extensive, exhaustive, thorough QA/UAT cycles with realistic loads, and you are willing to live on an unsupportable system with all that you have running now, then you may want to stick with wherever your testing has put you. In summary, a simplistic view to your situation has you classed into one of two conditions: 1. You do have the ability to patch the OS/Database/Application, but that is very limited AND Your test/QA/UAT cycle will be able to complete with the 9.2 db in place: * Go to 9.2 2. You do NOT have the ability to do anything but put on essential security patches (e.g. less than 60 seconds of downtime in a year) OR You do not have time to go through a test/QA/UAT cycle with 9.2 in place before you go live: * Stick with 9.0.1 I would do all I could to go with 9.2, but some situations simply don't allow for it. --- [EMAIL PROTECTED] wrote: > > We have a couple of new applications in development > that are moving to QA. > These databases are currently running 9.0.1.2 on Sun > Solaris 2.6. We've > been pretty happy with this version to this point > but are at a pivotal spot > in our product development cycle where we have a > narrow window in which we > could upgrade to 9.2 before we finish our QA cycle > and move the > application to production. We will be moving to > production in the > September timeframe. > > I know that 9.2 hasn't been out that long so I'm not > sure how many people > are using it. For those that are using it, what > has your experience been? > Is it very buggy? Any major problems? > > We have an OLTP database, a smallish datawarehouse > that uses partitioning, > and some datamarts that also use partitioning. We > do not use MTS or > replication. Our character set is UTF8. We will > be essentially 24 X 7. > These are web-based front-ends. > > What do you guys think? This OLTP database is very > mission critical for > us, once it gets to production. Is it worth moving > to 9.2 at this point > or should we wait awhile until a couple more > patchsets come out? How long > do people wait for a new release to settle before > they move to it? > > Thanks for your feedback, > > Cherie Machler > Oracle DBA > Gelco Information Network > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Michael P. Sale Author: Oracle9i on Windows 2000 Tips and Techniques __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Sale INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
