dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Shared_pool_reserved_size - Oracle FAQ

This is a discussion on Shared_pool_reserved_size - Oracle FAQ ; 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 ...


Home > Database Forum > Oracle Database > Oracle FAQ > Shared_pool_reserved_size

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 02-04-2008, 07:51 AM
Database Guru
  
Join Date: Jan 2008
Posts: 2,546
domregchief is on a distinguished road
Post 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.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 04:37 PM.