Re: plan_table performance

On Thu, Dec 17, 2009 at 3:57 PM, K  R <kp0773@xxxxxxxxx> wrote:
> I truncated the table  and tried . and getting the same waits issue.  the
> plan is taking somewhere around 20-30 sec to come out.
> I did a stats too  but  it do not seem to be helping .
> Normally I do the explain plan  in TOAD  but to rule out any slowness caused
> by TOAD  I tried doing it in sqlplus in database server but it still the
> same .
> it is a bit puzzling .

Hi

But what take long ?
explain plan for ......

or displaying plan from plan table using ex.
select * from table(dbms_xplan.display()); ?

regards,
Marcin Przepiorowski
--
http://www.freelists.org/webpage/oracle-l


Other related posts: