Integer 

Dynamic. Scope = ALTER SESSION. 

0 

0 to operating system dependent 

Multiple instances can have different values. 

SESSION_CACHED_CURSORS lets you specify the number of session cursors to cache. Repeated parse calls of the same SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Subsequent parse calls will find the cursor in the cache and need not reopen the cursor. 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: Oracle8i Designing and Tuning for Performance for more information on setting this parameter and its uses.