Search notes:

Oracle: Private SQL Area

The private SQL area stores the unshared (hence private) data that is needed to execute an SQL statement such as

bind variable values
query execution state information
query execution work area

Typically, the private SQL area is part of the PGA.

In a Shared Server environment, the private SQL area is part of the library cache.

Cursor

A cursor is the name or handle («pointer») of the private SQL area that is reserved for the processing of the corresponding SQL statement such as

bind variable values
result set

Division of the private SQL area

The private SQL area can be further subudivided into

run-time area
persistent area (which is freed when the corresponding cursor is closed)

See also

The shared SQL Area stores the information that is common to all executions of an SQL statement such as parse tree or execution plan.