| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 50 |
| Modifiable | ALTER SESSION |
| Range of values | 0 to operating system-dependent |
| 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 more information on setting this parameter and its uses