Oracle突然出现内存利用率很高的现象,最后找到两种解决方案
1. Option 1 , Tune below parameters:
MINPERM% = 10-15%,
MAXPERM% = 20-30%,
MAXCLIENT% = MAXPERM%
2. Option2 , For AIX 5.2 ML04+ and AIX 5.3 ML01+, As documented in the IBM "VMM Tuning Tip" referenced below, IBM is now recommending the follo
wing VMM settings for use with programs which need to protect computational memo
ry (like Oracle):
maxperm%=maxclient%=(A high value, typically 90%)
minperm%=(A low value, typically 10%)
strict_maxperm=0 (default)
strict_maxclient=1 (default)
lru_file_repage=0.
vmo -a查看参数
vmo -p -o lru_file_repage = 0 修改
阅读(1112) | 评论(0) | 转发(0) |