Name
SESSION_CACHED_CURSORS
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.