SERIAL_REUSE (Oracle8 Only)
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Name
SERIAL_REUSE (Oracle8 Only)
Synopsis
Values:DISABLE, SELECT, DML, PLSQL, ALL, or NULL
Default:NULL
Specifies which types of SQL cursors will make use of the serial-reusable memory feature, which moves well-structured private cursor memory into the SGA (shared pool) so that it can be reused by sessions executing the same cursor. Setting the parameter to the default NULL value is equivalent to setting it to DISABLE. The allowable values are listed in Table 12.6.
|
Value |
Description |
|
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 PL/SQL pragmas). |
|
ALL |
Enables the option for both DML and SELECT statements. Equivalent to setting SELECT, DML, and PLSQL. |
-
No Comment