The SGA includes several other pools:
- Large pool: Provides memory allocation for various I/O server processes, backup, and recovery, and provides session memory where shared servers and Oracle XA for transaction processing are used.
- Java pool: Provides memory allocation for Java objects and Java execution, including data in the Java Virtual Machine in the database.
- Streams pool: Provides memory allocation used to buffer Oracle Streams queued messages in the SGA instead of in database tables and provides memory for capture and apply.
Dynamic initialization parameters available for these pools include LARGE_POOL_SIZE, JAVA_POOL_SIZE, and STREAMS_POOL_SIZE.
These are automatically set if MEMORY_TARGET or SGA_TARGET is specified.