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 .


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

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

Marcin Przepiorowski

Other related posts: