Re: plan_table performance

From: K R <kp0773_at_gmail.com>
Date: Thu, 17 Dec 2009 09:39:11 -0800
Message-ID: <39a33df90912170939r1e26b2a3ubce16ced2695a314_at_mail.gmail.com>

well . I tried doing the explain plan for in sqlplus . it also takes the same time . so I created the index in sys.plan_table$ . but not much of help yet.

everytime I do see consistently the waits I mentioned in the thread earlier.

On Thu, Dec 17, 2009 at 9:35 AM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> You did create this index on TOAD_PLAN_TABLE? TOAD creates its own plan
> table to use for such operations.
>
>
> David Fitzjarrell
>
> ------------------------------
> *From:* K R <kp0773_at_gmail.com>
> *To:* daniel.fink_at_optimaldba.com
> *Cc:* oracle-l_at_freelists.org
> *Sent:* Thu, December 17, 2009 12:18:43 PM
>
> *Subject:* Re: plan_table performance
>
> my normal way is to do the explain plan using toad .
>
>
> but even I tested doing the explain plan for <stmt> in sqlplus and both
> taking long time.
>
> I am not using dbms_xplain
>
> On Thu, Dec 17, 2009 at 8:42 AM, Daniel W. Fink <
> daniel.fink_at_optimaldba.com> wrote:
>
>> What version of Oracle are you using? The plan_table changed from a
>> 'regular' table to a global temporary table in 10g.
>>
>> Are you using the explain plan for statement or dbms_xplan?
>>
>> Daniel Fink
>>
>> OptimalDBA http://www.optimaldba.com
>> Oracle Blog http://optimaldba.blogspot.com
>>
>> Lost Data? http://www.ora600.be/
>>
>>
>> ------- Original Message ------- Date: 12/17/2009 3:25 PM From: K R <
>> kp0773_at_gmail.com>
>> To:Oracle-L_at_freelists.org <To%3AOracle-L_at_freelists.org> Subject:
>> plan_table performance
>>
>>
>> All,In one of the database when I run the explain plan it takes a while
>> before I get the plan output . so I created a index on statement_id . but
>> still no luck.Anyone have any idea on how to resolve this . Appreciate any
>> suggestions!TIAKar
>>
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 17 2009 - 11:39:11 CST