Re: plan_table performance
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 17 Dec 2009 09:42:42 -0800 (PST)
Message-ID: <933910.42724.qm_at_web65415.mail.ac4.yahoo.com>
Date: Thu, 17 Dec 2009 09:42:42 -0800 (PST)
Message-ID: <933910.42724.qm_at_web65415.mail.ac4.yahoo.com>
You haven't mentioned which release of Oracle you're using; could you supply that information? David Fitzjarrell ________________________________ From: K R <kp0773_at_gmail.com> To: oratune_at_yahoo.com Cc: oracle-l_at_freelists.org 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_at_yahoo.com> 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_at_gmail.com> >To: daniel.fink_at_optimaldba.com >Cc: oracle-l_at_freelists.org >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_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-lReceived on Thu Dec 17 2009 - 11:42:42 CST