Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why so many LIO's for select statement doesn't fetch any rows?

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

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 31 Mar 2005 07:26:22 -0800
Message-ID: <1de5ebe7.0503310726.23fca2b8@posting.google.com>


"ashiqsham" <ashiqsham_at_gmail.com> wrote in message news:<1112268623.348009.218100_at_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
> ********************************************************************************

No query plan?

Guess: Using an index with statistics not up-to-date?

Try /*+ FULL */ hint and see what happens.

hth.

Carlos. Received on Thu Mar 31 2005 - 09:26:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US