RE: Re: plan_table performance

What version of the database? This is critical information.

Each release has it's own changes, bugs, issues, etc. There is little to be 
gained without knowing the release.

Daniel Fink

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com

Lost Data?    http://www.ora600.be/
------- Original Message -------
On 12/17/2009 5:18 PM K R wrote:
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 



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


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

Other related posts: