I am counfused about when Oracle database won't do parsing
1
vote
1
answer
637
views
I am confused about when Oracle database won't do parsing?
In the AWR report, there is a metrics called "execute to parse", which means more SQL just execute without parsing when it increases.
But as the Oracle document describe:
"When an application issues a SQL statement, the application makes a parse call to the database to prepare the statement for execution. "
It seems that everytime a SQL statement is issued, parsing will be called.
So I wandering when Oracle won't do parsing and make the "execute to parse" become a larger number?
Or I just misunderstood?
What Oracle document said is:
SQL Parsing
*The first stage of SQL processing is parsing.
The parsing stage involves separating the pieces of a SQL statement into a data structure that other routines can process. The database parses a statement when instructed by the application, which means that only the application, and not the database itself, can reduce the number of parses.
When an application issues a SQL statement, the application makes a parse call to the database to prepare the statement for execution.*
https://docs.oracle.com/database/121/TGSQL/tgsql_sqlproc.htm#TGSQL178
So if "an application issues a SQL statement, the application makes a parse call", then how applications "can reduce the number of parses"?
Asked by Jason Yang
(11 rep)
Apr 3, 2021, 12:55 PM
Last activity: Apr 4, 2021, 01:56 PM
Last activity: Apr 4, 2021, 01:56 PM