Re: plan_table performance

  • From: David Fitzjarrell <oratune@xxxxxxxxx>
  • To: K R <kp0773@xxxxxxxxx>
  • Date: Thu, 17 Dec 2009 09:42:42 -0800 (PST)

You haven't mentioned which release of Oracle you're using; could you supply 
that information?
 
David Fitzjarrell





________________________________
From: K R <kp0773@xxxxxxxxx>
To: oratune@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thu, December 17, 2009 12:39:11 PM
Subject: Re: plan_table performance

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 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: