RE: Re: plan_table performance

From: Daniel W. Fink <daniel.fink_at_optimaldba.com>
Date: Thu, 17 Dec 2009 17:41:31 +0000
Message-ID: <20091217174131.53801.qmail_at_optimaldba.com>



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_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 Received on Thu Dec 17 2009 - 11:41:31 CST

Original text of this message