Sample Header Ad - 728x90

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