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

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 26 Feb 2004 05:32:56 +0200
Message-ID: <216701c3fc19$39cb42b0$73f823d5@porgand>

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_at_freelists.org 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
-----------------------------------------------------------------

Received on Wed Feb 25 2004 - 21:30:33 CST