this is on 10.2.0.4 running in Redhat Linux on a RAC 2 node cluster using ASM On Thu, Dec 17, 2009 at 9:41 AM, Daniel W. Fink <daniel.fink@xxxxxxxxxxxxxx>wrote: > 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 <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 > > >