Re: plan_table performance

  • From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
  • To: kp0773@xxxxxxxxx
  • Date: Thu, 17 Dec 2009 16:01:44 +0000

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: