Re: Optimizer Puzzler

Is degree of parallelism same in both places for the table in question ?

-ak

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, April 22, 2003 7:41 AM

> Good day all,
> I have a query that has been a stumper for the past couple of days -
> Oracle 8.0.5
> HPUX 11
> When running it in Dev environment, it does a full table scan on a large
> table and the performance is terrible. But when running it in prod
> environment, it uses the index and the performance is great. Both Dev and
> Prod are running with Rule-based ( this is Oracle Apps so we don't have a
> choice ). Also Dev is a 'clone' of prod from about 2 weeks ago.
> The only thing I have a funny feeling about is that while Rule-based
> optimizer is set in init.ora, all the tables are analyzed with a 2001 date
(
> done by previous DBA ). But since both environment have the same
statistics,
> I don't think this can make a difference. I deleted statistics from the
> table in Dev and the plan remains the same.
>
> TIA
>
> Dennis
>
>
>
> 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: Meng, Dennis
> INET: Dennis.Meng_at_alcoa.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: AK
  INET: oramagic_at_hotmail.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).