Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | SERIAL_REUSE =
|
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:
IfCURSOR_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"