Re: plan_table performance

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