December 2002
Intermediate to advanced
928 pages
85h 29m
English
SESSION_CACHED_CURSORS
Value: 0-operating system dependent
Default: 0
Dynamic: ALTER SYSTEM
Specifies the maximum number of session cursors to keep in the session cursor 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 need not reopen the cursor.