SERIAL_REUSEparameter is deprecated. It is retained for backward compatibility only.
SERIAL_REUSE specifies which types of cursors make use of the serial-reusable memory feature. This feature allocates private cursor memory in the SGA so that it can be reused (serially, not concurrently) by sessions executing the same cursor.
Disables the option for all SQL statement types. This value overrides any other values included in the list.
Enables the option for both DML and
SELECT statements. Equivalent to setting
Enables the option for
Enables the option for DML statements.
Currently has no effect (although PLSQL packages do support the serial-reuse memory option using PLSQL pragmas).
CURSOR_SPACE_FOR_TIMEis set to
true, then the value of
SERIAL_REUSEis ignored and treated as if it were set to