RE: Should we upgrade from 9.0.1.2 to 9.2?

The choice should be between 9.0.1.3 + patch 2121935 or 9.2. The patch is to fix a serious, serious security problem with ANSI-style joins. If you feel the need to go to 9i, I'd choose the latter. I don't think 9.2 has been out long enough.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Tuesday, July 02, 2002 8:00 AM
To: Multiple recipients of list ORACLE-L

Cherie,

    Before any upgrade I consider whether or no I really need it. For mission critical application it would be wise to stick with what you have, unless you have problems with it.

    Now we have 9.0.1.2 in production and 9.1.3 in development and I don't intend to move to 9.2 in nearest time.

Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 02, 2002 3:58 PM

>
> 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: Cherie_Machler_at_gelco.com
>
> 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: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: alexandre.gorbatchev_at_avermann.de

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: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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: ListGuru_at_fatcity.com (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).