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

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Thu, 26 Feb 2004 08:23:02 -0800 (PST)
Message-ID: <20040226162302.68577.qmail@web13426.mail.yahoo.com>

This doesn't sound right to me, in fact it sounds backwards.

If an incoming SQL statement is found in the library cache, then that is evidence that it is syntactically and semantically correct. The soft parsing is required to resolve names, etc. within the context of the issuing session's privilege domain; this may lead to the creation of a new child cursor.

Paul Baumgartel

• Tanel_Põder <tanel.poder.003_at_mail.ee> wrote:
  > 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...
  

  ---

Do you Yahoo!?
Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools

---

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 Thu Feb 26 2004 - 10:30:33 CST