Why so many LIO's for select statement doesn't fetch any rows?

From: ashiqsham <ashiqsham_at_gmail.com>
Date: 31 Mar 2005 03:30:23 -0800
Message-ID: <1112268623.348009.218100@g14g2000cwa.googlegroups.com>

hi,

Can you explain me why so many LIO's , though sql fetches zero rows. See the below tkprof

SELECT UNQ_ATT_ID
FROM
ATTRIBUTE_VAL_HEADERS WHERE OBJECT_ID = :b1 AND DEFINITION_ID = :b2 AND
DATA_SOURCE = :b3

call count cpu elapsed disk query current

rows
------- ------ -------- ---------- ---------- ---------- ----------

Parse        1      0.00       0.00          0          0          0
       0
Execute   1772      1.19       1.32          0          0          0
       0
Fetch     1772      6.17       6.35          0     228471          0
       0

------- ------ -------- ---------- ---------- ---------- ----------

total     3545      7.36       7.67          0     228471          0
       0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 84 (recursive depth: 1)

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait  Total

Waited

Waited ----------
buffer busy waits 124 0.01 0.02 latch free 288 0.03 0.09 log file switch completion 2 0.17 0.25

Received on Thu Mar 31 2005 - 05:30:23 CST