Re: Apps 11.5.8 and 9i

I'd say you won't get too much performance improvements, because 11i is still optimized and will remain optimized for 8i, even lower in some cases, because it still uses 8.0 client libraries. (thus isn't using 9i construct such merge for example).

You could get some performance improvements because fixed optimizer bugs/issues, automatic PGA workarea sizing policy, that allows you to use memory more efficiently etc.. but I wouldn't expect any dramatic improvement. In fact if you're not ready for some tuning after the (test) upgrade, your performance might even drop.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 19, 2003 12:49 AM

> Has anyone upgraded Oracle Applications 11.5.8 from database version 8.1.7
to 9i? Was it good, bad,
> indifferent in regards to performance?
>
> I'd like to because of some of the database enhancements, but the CIO
asked the "performance"
> question.
>
> Thanks,
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> Each new user of a new system uncovers a new class of bugs. -- Kernighan
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).