|
Index >
ORACLE Server Parameters >
shared_pool_size
shared_pool_size
Oracle 11.1.0:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | TYPE=6
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | TYPE=6
| Obsoleted: | TRUE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | TYPE=6
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | TYPE=6
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.1.7:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | CHAR
| Obsoleted: | TRUE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 7.3.4:
| Parameter Name: | shared_pool_size
| | Description: | size in bytes of shared pool
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Related Error Messages:
ORA-00371: not enough shared pool memory, should be atleast %s bytes
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings Cause: Unable to set shared_pool_reserved_size to specified value if sga_target set, either because the specified value is too small, or because it is too large for the current internal size of shared pool. More details can be found in the alert log.Action: If possible, do not set shared_pool_reserved_size without setting shared_pool_size if sga_target set. Examine the alert log for information about current internal size of shared pool, and valid range of values for shared_pool_reserved_size.
ORA-16181: SGA specified for Logical Standby is too large Cause: MAX_SGA is larger than the larger of initialization parameters SHARED_POOL_SIZE and SGA_TARGET.Action: Specify the value of MAX_SGA to be less than the maximum of SHARED_POOL_SIZE and SGA_TARGET. Likely only 75% or lower.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ shared_pool_size ]
on the Oracle FAQ.
| 
