Synopsis

Values:TRUE or FALSE

Default:FALSE

Specifies whether cursors opened and cached in memory by PL/SQL are automatically closed at each COMMIT. A value of FALSE causes cursors opened by PL/SQL to be held open for use by subsequent executions. If PL/SQL cursors are reused frequently, this setting can speed up these subsequent executions. A value of TRUE causes open cursors to be closed at each COMMIT or ROLLBACK, and the cursor can then be reopened as needed. If cursors are rarely reused, setting the parameter to TRUE frees up memory the open cursor uses when idle.