Name
OPEN_CURSORS
Synopsis
Value: 1-4294967297
Default: 50
Specifies the maximum number of open cursors a session can have at once, preventing a session from opening an excessive number of cursors. No added overhead is incurred by setting this value too high. Also constrains the size of the PL/SQL cursor cache used to avoid having to reparse statements.
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.