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.