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