Hi Kirti,
No - I'm tracing because the query itself is taking hours. With traceonly the query should not execute and as far as I can tell it 'doesn't' - no dataset is returned, only the plan.
Thanks
-----Original Message-----
From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 6:15 PM
To: Multiple recipients of list ORACLE-L
Subject: 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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
