Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Initialization Parameters, 185 of 222
Parameter type |
String |
Syntax |
|
Default value |
|
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 |
|
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|