RE: HELP: Hanging Autotrace

He did say it was a Test!

So, my question is, should the stats be deleted or left alone after the 'test' is over?

AFAIK, analyzing sys objects is not recommended. Or is Oracle suggesting this to address such problems?

Lisa, do all other queries work fine without autotracing? And only Autotrace runs slow?

Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Koivu, Lisa [SMTP:lisa.koivu_at_efairfield.com]
> Sent: Thursday, June 07, 2001 4:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: HELP: Hanging Autotrace
>
> Are you kidding? I thought that Oracle adamantly stated that you are NOT
> to analyze the data dictionary...?
>
> Plus the user who is local can do it in a snap. I can't.
>
> I can explain plan on a very small query, yes.
>
> List, am I off track with thinking NOT to analyze the data dictionary??
>
> -----Original Message-----
> From: Riyaj_Shamsudeen_at_i2.com [SMTP:Riyaj_Shamsudeen_at_i2.com]
> Sent: Thursday, June 07, 2001 5:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: HELP: Hanging Autotrace
>
>
> Lisa
> Simple test: Can you do explain plan on some small query ? If it
> takes long time, then you know that your data dictionary uses CBO and
> access to DD is being slow. Try analyzing the data dictionary using
> 'dbms_utility.analyze_schema('SYS','COMPUTE') and in my case it fixed the
> problem...
>
> Thanks
> Riyaj "Re-yas" Shamsudeen
> Certified Oracle DBA
> i2 technologies www.i2.com
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).