Re: plan_table performance
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Thu, 17 Dec 2009 16:01:44 +0000
Message-ID: <3f5690af0912170801v4e2e17cbt94d92ff5efae72af_at_mail.gmail.com>
On Thu, Dec 17, 2009 at 3:57 PM, K R <kp0773_at_gmail.com> 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 .
Date: Thu, 17 Dec 2009 16:01:44 +0000
Message-ID: <3f5690af0912170801v4e2e17cbt94d92ff5efae72af_at_mail.gmail.com>
On Thu, Dec 17, 2009 at 3:57 PM, K R <kp0773_at_gmail.com> 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-lReceived on Thu Dec 17 2009 - 10:01:44 CST