Were tables/indexes anlayzed after the upgrade?
- Kirti
- Jeff Landers <jlanders_at_convergys.com> wrote:
> Hello All
>
> Version & OS:
> Upgraded from 9.0.1.4 (Sun Solaris 2.8) to 9.2.0.3.
>
> Problem:
> We've captured the sql text and optimization plans for critical sql
> prior to upgrading to 9.2. After the upgrade we have noticed
> that the cost associated with every sql statement is now HUGE
> compared to its 9.0.1.4 counterpart. Per the statistics being captured
> via traces,
> these statement are noticeably slower per execution.
>
> Anyone experiencing/experienced the same problem with 9.2?
>
> Thank you in advance.
>
>
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.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).
Received on Mon Sep 22 2003 - 18:10:03 CDT
