SQL> show parameter sga_target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_target big integer 584M SQL> select component,granule_size from v$sga_dynamic_components; shared pool 4194304 large pool 4194304 java pool 4194304 streams pool 4194304 DEFAULT buffer cache 4194304 KEEP buffer cache 4194304 RECYCLE buffer cache 4194304 DEFAULT 2K buffer cache 4194304 DEFAULT 4K buffer cache 4194304 DEFAULT 8K buffer cache 4194304 DEFAULT 16K buffer cache 4194304 DEFAULT 32K buffer cache 4194304 ASM Buffer Cache 4194304 13 rows selected SQL> alter system set sga_target = 1512m scope = spfile; System altered SQL> startup force; ORACLE 例程已经启动。 Total System Global Area 1585446912 bytes Fixed Size 1251484 bytes Variable Size 360712036 bytes Database Buffers 1216348160 bytes Redo Buffers 7135232 bytes 数据库装载完毕。 数据库已经打开。 SQL> select component,granule_size from v$sga_dynamic_components; COMPONENT GRANULE_SIZE ---------------------------------------------------------------- ------------ shared pool 8388608 large pool 8388608 java pool 8388608 streams pool 8388608 DEFAULT buffer cache 8388608 KEEP buffer cache 8388608 RECYCLE buffer cache 8388608 DEFAULT 2K buffer cache 8388608 DEFAULT 4K buffer cache 8388608 DEFAULT 8K buffer cache 8388608 DEFAULT 16K buffer cache 8388608 DEFAULT 32K buffer cache 8388608 ASM Buffer Cache 8388608 13 rows selected 各池大小 SQL> select pool,sum(bytes) from v$sgastat group by pool; POOL SUM(BYTES) ------------ ---------- 1216346268 java pool 8388608 shared pool 343937624 large pool 8388608 SQL>