SGA
-- 数据库块缓冲高速缓存 (db_cache_size)
-- 共享池 (shared_pool_size)
-- Java 池 (java_pool_size)
-- 大型池 (large_pool_size)
自动共享内存管理示例配置
SGA_TARGET(控制SGA的总大小) 设置为非零值
SGA
shared_pool_size = 0
large_pool_size = 0
java_pool_size = 0
db_cache_size = 0
SQL> select pool, sum(bytes)/1024/1024 Mbytes from v$sgastat group by pool;
POOL MBYTES
------------ ----------
303.996315
java pool 4
shared pool 102.490440
large pool 12
DB_CACHE_SIZE
SQL> select current_size from v$buffer_pool;
CURRENT_SIZE
------------
296
关闭自动大小调整
SGA_TARGET = 0