SERIAL _REUSE

Parameter type	String
Syntax	SERIAL_REUSE = {DISABLE | SELECT | DML | PLSQL | ALL}
Default value	DISABLE
Parameter class	Static

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.

Values:

• 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"