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

Home -> Community -> Mailing Lists -> Oracle-L -> Number of returned row(s) is greater than 0 while number of logical read

Number of returned row(s) is greater than 0 while number of logical read

From: Danisment Gazi Unal (Unal Bilisim) <danisment.unal_at_unal-bilisim.com>
Date: Tue, 26 Jun 2001 13:27:41 -0700
Message-ID: <F001.00338FC7.20010626133257@fatcity.com>

Hello,
When "Number of returned row(s) is greater than 0 while number of logical read is 0", itrprof
prompts error.
Some of itrprof users encounter this error. here is a line from raw file:
FETCH #3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=10,dep=0,og=3,tim=443263450 As you see, number of logical reads are 0, but number of returned rows are 10.
how is that possible ? I guess this is bug. have you encountered some problem. have you ever seen same problem in tkprof output ? thanks in advance... Received on Tue Jun 26 2001 - 15:27:41 CDT

Original text of this message

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