hello,
if EXPLAIN option is used, tkprof generates output
against current database statistics not against
statistics in raw file. this makes followings wrong:
- explain plan may be different than explain plan in
raw file since statistics may have changed after raw
file is generated.
- because of hard parse, execution plans of same SQLs
may be different. if you use aggregate=yes(which is
default), tkprof will show one execution plan.
I did not test for returned row. but, if explain plan
changes, returned row should be changed.
If there is "Row Source Operation" in your output, use
this one instead of explain plan section. "Row Source
Operation" shows exact execution plan in raw file.
regards...
- "Sam P. Roberts (ZADCO ITIS)"
<roberts_at_zadco.co.ae> 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
> --
> 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).
Danisment Gazi Unal
Web:
http://www.geocities.com/danisment
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment UNAL
INET: danisment_at_yahoo.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 Thu Feb 08 2001 - 04:35:48 CST
