String  

SERIAL_REUSE =

{DISABLE | SELECT | DML | PLSQL | ALL} 

Static  

DISABLE  

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. 

• DISABLE: disables the option for all SQL statement types. This value overrides any other values included in the list.

• SELECT: enables the option for SELECT statements.

• DML: enables the option for DML statements.

• PLSQL: currently has no effect (although PLSQL packages do support the serial-reuse memory option using PLSQL pragmas).

• ALL: enables the option for both DML and SELECT statements. Equivalent to setting SELECT, DML, and PLSQL.

Note: If CURSOR_SPACE_FOR_TIME is set to TRUE, then the value of SERIAL_REUSE is ignored and treated as if it were set to DISABLE.  

See Also: "CURSOR_SPACE_FOR_TIME".