RE: HELP: Hanging Autotrace

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Fri, 08 Jun 2001 04:58:29 -0700
Message-ID: <F001.00321F81.20010608045026@fatcity.com>

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:kirti.deshpande_at_verizon.com]
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: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).

Received on Fri Jun 08 2001 - 06:58:29 CDT