SESSION_CACHED_CURSORS


Property Description

Parameter type

Integer

Default value

50

Modifiable

ALTER SESSION

Range of values

0 to operating system-dependent

Basic

No

Oracle RAC

Multiple instances can have different values.


SESSION_CACHED_CURSORS specifies the number of session cursors to cache. Repeated parse calls of the same SQL (including recursive SQL) or PL/SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Oracle uses a least recently used algorithm to remove entries in the session cursor cache to make room for new entries when needed.

See Also:

Oracle Database Performance Tuning Guide for information about enabling the session cursor cache