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 .
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: