TKPROF

From: Sam P. Roberts (ZADCO ITIS) <roberts_at_zadco.co.ae>
Date: Wed, 07 Feb 2001 02:40:37 -0800
Message-ID: <F001.002AD648.20010207022525@fatcity.com>

This is the output from tkprof

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

Parse 1 0.02 0.02 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.34 1.73 83 385 0 7
------- ------ -------- ---------- ---------- ---------- ----------

total 4 0.36 1.75 83 385 0 7

Misses in library cache during parse: 1
Optimizer goal: RULE

Misses in library cache during parse: 1
Optimizer goal: RULE
Parsing user id: 36 (GL)

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: RULE
      0   NESTED LOOPS
      0    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
               'GL_BALANCES'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1'

My question - Why is the rows returned 7 in stats, yet the explain shows now Rows:

Thanks

Sam
--

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

Author: Sam P. Roberts (ZADCO ITIS)
INET: roberts_at_zadco.co.ae

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 Wed Feb 07 2001 - 04:40:37 CST