RE: Re: plan_table performance
- From: "Daniel W. Fink" <daniel.fink@xxxxxxxxxxxxxx>
- To: kp0773@xxxxxxxxx
- Date: Thu, 17 Dec 2009 17:41:31 +0000
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
