December 2002
Intermediate to advanced
928 pages
85h 29m
English
OPEN_CURSORS
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.