大家好，又见面了，我是你们的朋友全栈君。
SGA_MAX_SIZE: static parameter
To use ASMM，need two parameters:
1.SGA_TARGET not null or zero;
2.STATISTICS_LEVEL = TYPICAL ( or ALL)
when u use ASMM,the sga is auto management
example:
SGA_MAX_SIZE : 12G
SGA_TARGET : 10G
2G (12G-10G) memory is not use at all.
parameters:
LOG_BUFFER=1G;( the parameter is only for the example and assume there is no fixed sga ,actually it is impossible)
other parameters = 0
steps:
1.
ALTER SYSTEM SET DB_CACHE_SIZE=8G； — succeed!
2.
ALTER SYSTEM SET DB_CACHE_SIZE=2G; — succeed!
3.
ALTER SYSTEM SET SHARED_POOL_SIZE=6G; — succeed!
4.
ALTER SYSTEM SET SHARED_POOL_SIZE=1G; — succeed!
5.
ALTER SYSTEM SET DB_CACHE_SIZE=4G; — failed !
SHOW PARAMETER SHARED_POOL_SIZE
it will display: 1G
u can not manually set the DB_CACHE_SIZE to 4G，unless u disable the ASMM.
—————————————
SHARED_POOL_SIZE,
LARGE_POOL_SIZE,
JAVA_POOL_SIZE,
STREAMS_POOL_SIZE
will the same result.
—————————————
DB_KEEP_CACHE_SIZE,
DB_RECYCLE_CACHE_SIZE,
nK BLOCK CACHE SIZE
are not the same result.
If u use DB_KEEP_CACHE_SIZE replaces SHARED_POOL_SIZE,
step 5 will succeed!
—————————————
doc says:
DB_KEEP_CACHE_SIZE is manual component ,so when it shrink,the auto components can use the memory immediate.
but:
DB_CACHE_SIZE is auto too! when shrink this parameter,query v$sgainfo and
v$sga_dynamic_comonents ,it size does not change, but the memory can be used immediate.
see : step 1,2,3
so i guess parameter “cache” is different from “pool”.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12807983/viewspace-695771/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/12807983/viewspace-695771/
发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/133693.html原文链接：https://javaforall.cn
【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛
【官方授权 正版激活】： 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...
