Home > database >  When the Oracle does not do to SQL parsing performed directly?
When the Oracle does not do to SQL parsing performed directly?

Time:04-04

A execute to parse indicators of who runs AWR, the greater the number shows that direct execution is not parsed, the greater the proportion of SQL
But oracle documents described as follows:

SQL Parsing
The first stage of SQL processing is parsing.

The parsing stage involves particulary if 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.

the When an application issues a SQL statement, the application top service parse the call to the database to prepare the statement for execution.

Two key points:
1, do you want to listen to database parsing instruction, only program can reduce the parsing
Issue a SQL program 2, whenever, it would send a parse call

Both looks a bit contradictory, whenever the program issued a call, send out the parse SQL is that enter the parsing process is not already?
How to make the program parsing database does not do?
  • Related