Name
CLOSE_CACHED_OPEN_CURSORS
Synopsis
Value: TRUE | FALSE
Default: FALSE
Specifies whether cursors opened and cached in memory by PL/SQL are automatically closed at each COMMIT. If PL/SQL cursors are reused frequently, FALSE can cause subsequent executions to be faster. TRUE causes open cursors to be closed at each COMMIT or ROLLBACK, and the cursor can then be reopened as needed. Obsolete with Oracle8i.
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.
