oracle 清理sga,ORACLE10g 自动SGA治理(一)

ORACLE10g 自动SGA管理(一)

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