Cursor Sharing in Oracle
Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server process executes SQL or PL/SQL code, the process uses the private SQL area to store bind variable values, query execution state information, and query execution work areas. The private SQL areas for each execution of … Read more