Re: Oracle9i v/s 8i performance ?

OT a little, support seems to be a big issue. Security patchsets have not been produced for 8 or 8i for the last collection of holes. Course, you db will not perform well if the axis of evil gets in. You do get this keen "Unbreakable" logo on the side, however.

On Thu, Apr 24, 2003 at 08:02:05AM -0800, DENNIS WILLIAMS wrote:
> Jackson
> I think the answer is a big "it depends". Just moving an application to
> 9i with no attempt to take advantage of new 9i features would probably yield
> only small changes to performance. Depending on your application, the effect
> may not be noticeable, but might be significant. Hard to generalize. One
> step would be to review the Oracle literature (http:technet.oracle.com) and
> see if any new built-in features seem to apply to your situation. The next
> question is whether you can make some small change to your application that
> might reap significant benefits.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Thursday, April 24, 2003 7:57 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Good day
>
> I just wanted to find out about the performance comparison between
> Oracle9i and Oracle8i or Oracle 8.0.X.
>
> Does a new release of oracle software have any enhancement, better
> performance, given that its requirements are met ?
> Looking at 9i's requirements, or say generaly every new release of
> Oracle normally require more memory, disk space, etc than the
> previous.
> That being the case, does that guarentee any performance improvement
> or degradation in performance ?
>
> Thank you, please respond for help on this
>
>
>
> _______________________________________________________________________
> Cool Connection, Cool Price, Internet Access for R59 monthly @ WebMail
> http://www.webmail.co.za/dialup/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jackson Dumas
> INET: tjaros_at_webmail.co.za
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).