1.302 SERIAL_REUSE

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.
Property Description

Parameter type

String

Syntax

SERIAL_REUSE = { disable | all | select | dml | plsql | force }

Default value

disable

Modifiable

No

Modifiable in a PDB

No

Basic

No

Note:

The SERIAL_REUSE parameter is deprecated. It is retained for backward compatibility only.

Values

  • disable

    Disables the option for all SQL statement types. This value overrides any other values included in the list.

  • all

    Enables the option for both DML and SELECT statements. Equivalent to setting select, dml, and plsql.

  • select

    Enables the option for SELECT statements.

  • dml

    Enables the option for DML statements.

  • plsql

    Currently has no effect (although PL/SQL packages do support the serial-reuse memory option using PL/SQL pragmas).

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"