Shared_pool_reserved_sizeThis is a discussion on Shared_pool_reserved_size within the Oracle FAQ forums in Oracle Database category; Type:Big integer Syntax:SHARED_POOL_RESERVED_SIZE = integer [K | M | G] Default:5% of the value of SHARED_POOL_SIZE Modify:No Range:Minimum: 5000 Maximum: one half of the value of SHARED_POOL_SIZE Notes: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.... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
02-04-2008, 07:51 AM
|
 Shared_pool_reserved_size Type:Big integer Syntax:SHARED_POOL_RESERVED_SIZE = integer [K | M | G] Default:5% of the value of SHARED_POOL_SIZE Modify:No Range:Minimum: 5000 Maximum: one half of the value of SHARED_POOL_SIZE Notes: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.  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 04:41 PM.
