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 -- //www.freelists.org/webpage/oracle-l