Re: how to get parse and execution number for a sql
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Feb 2004 19:06:46 +0200
Yes, parse always happens when you issue a sql statement.
Tanel.
----- Original Message -----
From: "Powell, Mark D" <mark.powell@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, February 26, 2004 6:51 PM
Subject: RE: how to get parse and execution number for a sql
> Paul, if you look at the (9.2) glossary Oracle definitely implies that it
> always checks the syntax before it looks in the shared pool for the SQL:
>
> parse call
> A call to Oracle to prepare a SQL statement for execution. This includes
> syntactically checking the SQL statement, optimizing it, and building (or
> locating) an executable form of that statement.
>
> I realize the manuals are not always very precise, but in the last week I
> have just read a post by Tom Kyte on the parse order where he explained
the
> difference between checking syntax and semantics and the definition
follows
> what he said.
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paul Baumgartel
> Sent: Thursday, February 26, 2004 11:23 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: how to get parse and execution number for a sql
>
>
> 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_Poder <tanel.poder.003@xxxxxxx> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
