Re: plan_table performance
- From: K R <kp0773@xxxxxxxxx>
- To: oratune@xxxxxxxxx
- Date: Thu, 17 Dec 2009 09:39:11 -0800
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@xxxxxxxxx>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@xxxxxxxxx>
> *To:* daniel.fink@xxxxxxxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxxxxxxx> 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@xxxxxxxxx>
>> To:Oracle-L@xxxxxxxxxxxxx <To%3AOracle-L@xxxxxxxxxxxxx> 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
>>
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
Other related posts:
