December 2002
Intermediate to advanced
928 pages
85h 29m
English
SERIAL_REUSE
Value: DISABLE | SELECT | DML | PLSQL | ALL | NULL
Default: DISABLE
Specifies which types of SQL cursors should make use of the serially reusable memory feature. Moves well-structured private cursor memory into the SGA shared pool so that it can be reused 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 SELECT statements.
Enables the option for DML statements.
Currently has no effect.
Enables the option for both DML and SELECT statements.
Equivalent to DISABLE.