You haven't mentioned which release of Oracle you're using; could you supply that information? David Fitzjarrell ________________________________ From: K R <kp0773@xxxxxxxxx> To: oratune@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: Thu, December 17, 2009 12:39:11 PM Subject: Re: plan_table performance well . I tried doing the explain plan for in sqlplus . it also takes the same time . so I created the index in sys.plan_table$ . but not much of help yet. everytime I do see consistently the waits I mentioned in the thread earlier. On Thu, Dec 17, 2009 at 9:35 AM, David Fitzjarrell <oratune@xxxxxxxxx> wrote: You did create this index on TOAD_PLAN_TABLE? TOAD creates its own plan table to use for such operations. > > >David Fitzjarrell > > > > ________________________________ >From: K R <kp0773@xxxxxxxxx> >To: daniel.fink@xxxxxxxxxxxxxx >Cc: oracle-l@xxxxxxxxxxxxx >Sent: Thu, December 17, 2009 12:18:43 PM > >Subject: Re: plan_table performance > > >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 >> >> >> > >