RE: Number of returned row(s) is greater than 0 while number of l

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 26 Jun 2001 14:42:03 -0700
Message-ID: <F001.003391A2.20010626144241@fatcity.com>

What is <http://www.unal-bilisim.com/products/itrprof/itrprof.html> itrprof?

-----Original Message-----
[mailto:danisment.unal_at_unal-bilisim.com] Sent: Tuesday, June 26, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L read

Hello,

When "Number of returned row(s) is greater than 0 while number of logical read is 0", itrprof
<http://www.unal-bilisim.com/products/itrprof/itrprof.html> 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...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jun 26 2001 - 16:42:03 CDT