SERIAL _REUSE

Property Description
Parameter type String
Syntax SERIAL_REUSE =

{ DISABLE | SELECT | DML | PLSQL | ALL }
Default value DISABLE
Modifiable No

Note:

This parameter is deprecated. It is retained for backward compatibility only.

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"