发表于 2009-1-5 19:48
| 
濡備綍澧炲姞ORACLE杩炴帴鏁
鍙戝竷: 2008-6-30 14:56 | 浣滆: admin | 鏌ョ湅: 14娆
濡備綍澧炲姞ORACLE杩炴帴鏁
鐑 鑽
銆愬瓧浣擄細灏 澶с
濡備綍澧炲姞ORACLE杩炴帴鏁
浣滆咃細浣氬悕 鏂囩珷鏉ユ簮锛氫笉璇 鐐瑰嚮鏁帮細1003 鏇存柊鏃堕棿锛2006-4-17 
ORACLE鐨勮繛鎺ユ暟(sessions)涓庡叾鍙傛暟鏂囦欢涓殑杩涚▼鏁(process)鏈夊叧锛屽畠浠殑鍏崇郴濡備笅锛
sessions=(1.1*process+5)
浣嗘槸鎴戜滑澧炲姞process鏁版椂锛屽線寰鏁版嵁搴撲笉鑳藉惎鍔ㄤ簡銆傝繖鍥犱负鎴戜滑杩樻紡璋冧簡涓涓猽nix绯荤粺鍙傛暟锛氬畠鏄/etc/system/ 涓璼emmns,杩欐槸unix绯荤粺鐨勪俊鍙烽噺鍙傛暟銆傛瘡涓猵rocess浼氬崰鐢ㄤ竴涓俊鍙烽噺銆俿emmns璋冩暣鍚庯紝
闇瑕侀噸鏂板惎鍔╱nix鎿嶄綔绯荤粺锛屽弬鏁版墠鑳界敓鏁堛備笉杩囧畠鐨勫ぇ灏忎細鍙楀埗浜庣‖浠剁殑鍐呭瓨鎴朞RACLE SGA銆傝寖鍥
鍙粠200鈥曗2000涓嶇瓑銆
semmns鐨勮绠楀叕寮忎负锛歋EMMNS>processes+instance_processes+system
processes=鏁版嵁搴撳弬鏁皃rocesses鐨勫 instance_processes=5(smon,pmon,dbwr,lgwr,arch)
system=绯荤粺鎵鍗犵敤淇″彿閲忋傜郴缁熸墍鍗犵敤淇″彿閲忓彲鐢ㄤ笅鍒楀懡浠ゆ煡鍑猴細#ipcs -sb
鍏朵腑鍒桸SEMS鏄剧ず绯荤粺宸插崰鐢ㄤ俊鍙烽噺銆
鍏跺畠涓浜涜窡杩炴帴鏈夊叧鐨勫弬鏁帮紝濡 licence_max_sessions, licence_sessions_warning 绛夐粯璁よ缃兘涓
闆讹紝涔熷氨鏄病鏈夐檺鍒躲傛垜浠彲浠ユ斁蹇冨ぇ鑳嗗湴浣跨敤鏁版嵁搴撲簡銆
銉
