The document gives a overview of Parsing.
For users requiring a general overview of how parsing works.
This article show the parsing mechanism as a flow diagram.
explanation of parsing activity easier.
location of a SQL statement on the server.
Multiple-client cursors may point at the same address on the server.
machine - in which case Client/Server is a logical distinction.
so no parsing is necessary.
specifies how many cursors to hold open for a particular session.
individual cursor should be held open.
See Page 11-3 of the Programmer's guide to the Oracle Precompilers.
current statement updates the parse count.
and relatively expensive steps (such as query optimization etc.) are avoided.
8. The 10053 event is only invoked during a hard parse.
cursor：from Oracle9i Database Concepts：A cursor is a handle or name for a private SQL area--an area in memory in which a parsed statement and other information for processing the statement are kept.