ashiqsham wrote:
> 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
> ********************************************************************************
>
How would Oracle know, no record matches your criteria?!?
Perhaps by inspecting them?
--
Regards,
Frank van Bortel
Received on Thu Mar 31 2005 - 07:40:08 CST
