LARGEPOOLSIZE - Dynamic parameter that specify or adjust size of large pool component of SGA - Oracle DBA

Discussion

• Nirja Shah   -Posted on 24 Aug 15
  - The large pool buffer is an important part of the Oracle 11g SGA that provides the following functions:
  
  - Parallel Query performance management.
  - Recovery Manager (RMAN) backup and recovery operations.
  - Shared Server operations (MTS) - NOT recommended!
  
  
  -LARGE_POOL_SIZE - It specifies (in bytes) the size of the large pool allocation heap.
  -The large pool allocation heap is used in shared server systems for session memory, by parallel execution for message buffers, and by backup processes for disk I/O buffers.
  -Parallel execution allocates buffers out of the large pool only when SGA_TARGET is set.
  
  - STREAMS_POOL_SIZE - It is the initialization parameter also is set to a nonzero value, then Automatic Shared Memory Management uses this value as a minimum for the Streams pool.
  
  -JAVA_POOL_SIZE - It specifies (in bytes) the size of the Java pool, from which the Java memory manager allocates most Java state during runtime execution.
  
  -SHARED_POOL_SIZE - It specifies (in bytes) the size of the shared pool. The shared pool contains shared cursors, stored procedures, control structures, and other structures

➨ Post your comment / Share knowledge