oracle10G -- 使用automatic memory management 功能

<自動管理SGA>(ASMM)
Background process : MMAN
Enable Automatic SGA:
設statistics_level to typical 或 all (同時也啟動 The Automatic Workload Repository AWR功能)
設sga_target 大於 0
1.oracle 建議不要設sga_max_size參數

2.SGA包含下列兩種記憶體 : oracle 管理記憶體, user自定記憶體
2.1 oracle 建議不要更改 下列四個auto-tuned 參數, oracle server 會自行管理
Automatically Managed SGA Components
Buffer cache(DB_CACHE_SIZE)
Shared pool(SHARED_POOL_SIZE)
Large pool(LARGE_POOL_SIZE)
Java pool(JAVA_POOL_SIZE)

2.2 Manually Sized SGA Components
You are using automatic shared memory management configuration.
Which five initialization parameters will take their memory from the SGA_TARGET paramete
(1)LOG_BUFFER
(2)DB_nk_CACHE_SIZE
(3)STREAMS_POOL_SIZE
(4)DB_KEEP_CACHE_SIZE
(5)DB_RECYCLE_CACHE_SIZE

限定使用總sga記憶體 SGA_MAX_SIZE

3.動態修改sga_target 的值
alter system set sga_target = 600M

相關VIEW
v$vgastat, v$sga

<自動管理PGA>
Enable Automatic PGA:
workarea_size_policy 設auto
PGA_AGGREGATE_TARGET > 0