From henrik.ekenberg@anoto.com Thu, 08 Feb 2001 01:54:08 -0800 From: Henrik Ekenberg Date: Thu, 08 Feb 2001 01:54:08 -0800 Subject: Re: TKPROF Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hello, Do you have timed_statistics = true in your init file ? Regards Henrik Sam P. Roberts (ZADCO ITIS) wrote: > 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 -- --------------------------------------------------------------------------- Henrik Ekenberg Anoto AB E-mail :henrik.ekenberg@anoto.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: henrik.ekenberg@anoto.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@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).