shared server模式下,UGA放在SGA的哪个位置?如果配置了LARGE POOL,UGA就会放在LARGE POOL中;否则如果没有配置,那么就存放在SHARED POOL当中.
oracle 11g以后,可以将sql,pl/sql的执行结果存放在result pool中.
Shared Pool
Contents:
- Library cache:Command text,parsed code,and execution plan
- Data dictionary cache:Definitions for tables,columns,and privileges from the data dictionary tables
- Result cache:Results from SQL queries and PL/SQL functions
- User Global Area(UGA):Session information for the Oracle shared server
- Is sized with the SHARED_POOL_SIZE parameter
Large Pool
- Provides large memory allocations for:
- Session memory for the shared server and the Oracle XA interface
- I/O server processes
- Oracle Database backup and restore operations
- Parallel query operations
- Advanced Queuing memory table storage
- Reduces potential framentation of shared pool
- Is managed by AMM and ASMM
- Is sized with the LARGE_POOL_SIZE parameter