Re: plan_table performance
- From: K R <kp0773@xxxxxxxxx>
- To: daniel.fink@xxxxxxxxxxxxxx
- Date: Thu, 17 Dec 2009 09:18:43 -0800
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:
