Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Number of returned row(s) is greater than 0 while number of logical read
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