[bbk5131] 第47集 - 第五章 管理内存 02

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