SQL> select pool, sum(bytes)/1024/1024 Mbytes from v$sgastat group by pool;
POOL
MBYTES
----------- ----------
java pool 16
large pool
16
shared pool176
515.949295
参数里面是是 *.java_pool_size=15829120 (15M)
数据库版本是
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
[ 本帖最后由 xin2v 于 2009-10-21 16:43 编辑 ]
至少一个granule大小。
Granule size is determined by total SGA size. On most platforms, the size of a granule is 4 MB if the total SGA size is less than 128 MB, and it is 16 MB for larger SGAs. There may be some platform dependency, for example, on 32-bit Windows NT, the granule size is 8 MB for SGAs larger than 128 MB.
说了以granule为单位,至少一个granule大小,也就是至少16MB,其余是16的倍数。你large_pool设置为16m,还会怎么改?
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%_ksmg_granule_size%'
/