自动SGA管理(Automatic Shared Memory Management)

自动SGA管理(Automatic Shared Memory Management) #

1. 把数据库的统计级别设置成TYPICAL或ALL

ALTER SYSTEM SET STATISTICS_LEVEL=TYPICAL;

1. 计算SGA的目标值（SGA_TARGET）

(SELECT SUM(value) FROM V$SGA) - (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY)

1. 设置SGA目标值

ALTER SYSTEM SET SGA_TARGET = 1000M SCOPE=BOTH;

1. 把SGA相关内存组件的大小设置为0

SHARED_POOL_SIZE, LARGE_POOL_SIZE, JAVA_POOL_SIZE, DB_CACHE_SIZE, STREAMS_POOL_SIZE

From #

Links #