SERIAL_REUSE

1.286 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.