Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Taking a while to generate a query plan?
But you have 4.39 seconds of elapsed time here? You mentioned about 30
seconds earlier. Probably because you didn't hard parsed that
query?...
How many segments do you have in that table?
I saw hard parse taking as much as 5 minutes with tables what had a lot of segments (300K+).
On 6/1/07, Don Seiler <don_at_seiler.us> wrote:
> call count cpu elapsed disk query current rows
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> Parse 1 0.00 0.00 0 0 0 0
> Execute 1 0.00 0.00 0 0 0 0
> Fetch 14 4.38 4.38 33190 34397 0 184
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> total 16 4.38 4.39 33190 34397 0 184
>
-- Alexander Fatkulin -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 01 2007 - 17:05:48 CDT
![]() |
![]() |