SHARED_POOL_RESERVED_SIZE

Property	Description
Parameter type	Big integer
Syntax	`SHARED_POOL_RESERVED_SIZE =` `integer` `[K \| M \| G]`
Default value	5% of the value of `SHARED_POOL_SIZE`
Modifiable	No
Range of values	Minimum: `5000` Maximum: one half of the value of `SHARED_POOL_SIZE`

SHARED_POOL_RESERVED_SIZE specifies (in bytes) the shared pool space that is reserved for large contiguous requests for shared pool memory.

You can use this parameter to avoid performance degradation in the shared pool in situations where pool fragmentation forces Oracle to search for and free chunks of unused pool to satisfy the current request.

See Also:

Oracle Database Performance Tuning Guide for more information on setting this parameter
"SHARED_POOL_SIZE"

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Reference 11g Release 2 (11.2)
Initialization Parameters
Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES
Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
Dynamic Performance (V$) Views: V$INDEXED_FIXED_COLUMN to V$RULE_SET_AGGREGATE_STATS
Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$XSTREAM_TRANSACTION
Database Limits
SQL Scripts
Oracle Wait Events
Oracle Enqueue Names
Statistics Descriptions
Background Processes

New and changed documents:

HTML

PDF