Re: how to get parse and execution number for a sql

Hi!

> -- Why it is not 2,3,1  (again assuming 2,2,0 was correct) ?  Does
> PARSE_CALLS include both hard parse and soft parse?

Yes, parse_calls shows any parse calls. A parse is always a parse. You can't
avoid parsing when you issue a SQL statement to be executed. Syntax and
semantics check is always done. Only after that if Oracle finds out that
required statement is already parsed against the correct objects, correct
bind variable types and with correct session parameters, then it can skip
the rest of parsing and use the already parsed statement.

You can use session statistics parse count (total) and parse count (hard) to
find out whether a parse was soft or hard...

Tanel.



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: