发表于 2009-1-5 19:48
| 
ORACLE SGA 鐨勫垎閰
鍙戝竷: 2008-6-30 14:56 | 浣滆: admin | 鏌ョ湅: 4娆
ORACLE SGA 鐨勫垎閰
鐑 鑽
銆愬瓧浣擄細灏 澶с
ORACLE SGA 鐨勫垎閰
浣滆咃細浣氬悕 鏂囩珷鏉ユ簮锛氫笉璇 鐐瑰嚮鏁帮細1161 鏇存柊鏃堕棿锛2006-4-17 
ORACLE 8.0.X 鐗堟湰
SGA=((db_block_buffers * block size)+(shared_pool_size+large_pool_size+log_buffers)+1MB
ORACLE 8.1.X 鐗堟湰
SGA=((db_block_buffers * block size)+(shared_pool_size+large_pool_size+java_pool_size+log_buffers)+1MB
鐞嗚涓奡GA鍙崰OS绯荤粺鐗╃悊鍐呭瓨鐨1/2鈥曗1/3锛屾垜浠彲浠ユ牴鎹渶姹傝皟鏁
鎴戞帹鑽怱GA=0.45*(OS RAM)
鍋囪鏈嶅姟鍣ㄨ繍琛孫RACLE 8.1.X 鐗堟湰, OS绯荤粺鍐呭瓨涓2G MEM, db_block_size 鏄8192 bytes,
闄や簡杩愯ORACLE鏁版嵁搴撳, 娌℃湁鍏跺畠鐨勫簲鐢ㄧ▼搴忔垨鏈嶅姟鍣ㄨ蒋浠.
杩欐牱SGA鍚堣绾︿负921M ( 0.45*2048M ),
璁緎hared_pool_size 250M (250*1024*1024 bytes)
璁綿atabase buffer cache 620M (79360*8192 bytes)
initorasid.ora鏂囦欢閲屽叿浣撳悇鍙傛暟濡備笅:
shared_pool_size = 262144000
# 250 M
db_block_buffers = 79360
# 620 M
log_buffer = 524288
# 512k (128K*CPU涓暟)
large_pool_size = 31457280
# 30 M
java_pool_size = 20971520
# 20 M
sort_area_size = 524288
# 512k (65k--2M)
sort_area_retained_size = 524288
# MTS 鏃 sort_area_retained_size = sort_area_size
SUN Solaris閲/etc/system鏂囦欢閲岀殑鍑犱釜鍙傛暟鍚屾牱璺熷唴瀛樺垎閰嶆湁鍏
ORACLE瀹夎鏃剁己鐪佺殑璁剧疆:
寤鸿淇敼鐨勮缃:
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=15
set semsys:seminfo_semmns=200
set semsys:seminfo_semmni=70
set ulimit=3000000
set semsys:seminfo_semmni=315
set semsys:seminfo_semmsl=300
set semsys:seminfo_semmns=630
set semsys:seminfo_semopm=315
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=315
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmin=1
鍏朵腑杩欎簺鍙傛暟鐨勫惈涔
shmmax - 鍏变韩鍐呭瓨娈电殑鏈澶у瓧鑺傛暟锛屽缓璁澶х偣锛岀敋鑷冲彲浠ュぇ杩囩墿鐞嗗唴瀛樼殑瀛楄妭鏁
shmmin - 鍏变韩鍐呭瓨娈电殑鏈灏忓昂瀵.
shmmni - 鍏变韩鍐呭瓨娈电殑鏈澶ф暟鐩.
shmseg - 姣忎釜杩涚▼鍙垎閰嶇殑鏈澶у叡浜唴瀛樻鏁扮洰.
shmall - 鏈澶х殑骞跺彂鍏变韩鍐呭瓨娈垫暟鐩紝姣擲GA杩樿澶.
semmns - 淇″彿鐏殑鏈澶ф暟閲忥紝璺烵RACLE鐨凱ROCESS鏁版湁鍏.
semmsl - 姣忎釜淇″彿鐏泦鍚堜腑鏈澶氱殑淇″彿鐏暟鐩.
銉
