|
[oracle-l]
||
[Date Prev]
[06-2007 Date Index]
[Date Next]
||
[Thread Prev]
[06-2007 Thread Index]
[Thread Next]
Re: Taking a while to generate a query plan?
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: don@xxxxxxxxx
- Date: Fri, 1 Jun 2007 18:05:48 -0400
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@xxxxxxxxx> 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-l
|
