"BB站台連線異常" 修訂間的差異
(新頁面: Q: BB站台連線異常是的錯誤訊息ORA-00018: maximum number of sessions exceeded A: 超出session最大值~可試試再增加oracle的process和session參數 原廠建議調校...) |
|||
| (未顯示同一使用者於中間所作的 3 次修訂) | |||
| 行 1： | 行 1： | ||
Q: BB站台連線異常是的錯誤訊息ORA-00018: maximum number of sessions exceeded | Q: BB站台連線異常是的錯誤訊息ORA-00018: maximum number of sessions exceeded | ||
| − | A: 超出session最大值~ | + | A: 超出session最大值~可試試再增加oracle的process和session參數，經過討論 oracle process 改為500。 |
| − | + | 其他參數由原廠建議調校數據如下 | |
I. Database changes | I. Database changes | ||
| − | + | ------------------------------------- | |
| − | *max number of semaphore identifiers: | + | \*max number of semaphore identifiers: |
| + | |||
set semsys:seminfo_semmni=50 | set semsys:seminfo_semmni=50 | ||
| − | * | + | |
| − | *max number of semaphores per identifier: | + | \* |
| − | *semmsl=largest number of processes of all instances < 512 | + | |
| + | \*max number of semaphores per identifier: | ||
| + | |||
| + | \*semmsl=largest number of processes of all instances < 512 | ||
| + | |||
set semsys:seminfo_semmsl=500 | set semsys:seminfo_semmsl=500 | ||
| − | * | + | |
| − | *max number of semaphores: semmns=semmni*semmsl | + | \* |
| − | *semmns>=sum of all processes of all instances | + | |
| − | *semmns>=semmni*semmsl | + | \*max number of semaphores: semmns=semmni*semmsl |
| + | |||
| + | \*semmns>=sum of all processes of all instances | ||
| + | |||
| + | \*semmns>=semmni*semmsl | ||
| + | |||
set semsys:seminfo_semmns=25000 | set semsys:seminfo_semmns=25000 | ||
| + | |||
set semsys:seminfo_semopm=100 | set semsys:seminfo_semopm=100 | ||
| + | |||
set semsys:seminfo_semvmx=32767 | set semsys:seminfo_semvmx=32767 | ||
II. Appserver changes | II. Appserver changes | ||
| − | ********************* | + | |
| + | \********************* | ||
| + | |||
bbconfig.unix.httpd.maxclients= 200 | bbconfig.unix.httpd.maxclients= 200 | ||
| + | |||
bbconfig.appserver.maxthreads= 200 | bbconfig.appserver.maxthreads= 200 | ||
| + | |||
bbconfig.database.bb_60.db.maxpoolsize= 200 | bbconfig.database.bb_60.db.maxpoolsize= 200 | ||
| + | |||
bbconfig.database.bb_60.db.minpoolsize= 50 | bbconfig.database.bb_60.db.minpoolsize= 50 | ||
| + | |||
bbconfig.max.heapsize.tomcat= 1024m | bbconfig.max.heapsize.tomcat= 1024m | ||
| + | |||
bbconfig.min.heapsize.tomcat= 512m | bbconfig.min.heapsize.tomcat= 512m | ||
| + | |||
bbconfig.unix.modperl.keepalive= Off | bbconfig.unix.modperl.keepalive= Off | ||
| + | |||
bbconfig.unix.modperl.maxclients= 20 | bbconfig.unix.modperl.maxclients= 20 | ||
| + | |||
bbconfig.unix.modperl.maxspareservers= 10 | bbconfig.unix.modperl.maxspareservers= 10 | ||
| + | |||
bbconfig.unix.modperl.minspareservers= 3 (or 5) | bbconfig.unix.modperl.minspareservers= 3 (or 5) | ||
| + | |||
bbconfig.unix.modperl.startservers= 10 | bbconfig.unix.modperl.startservers= 10 | ||
| + | |||
bbconfig.unix.httpd.maxspareservers= 50 | bbconfig.unix.httpd.maxspareservers= 50 | ||
| + | |||
bbconfig.unix.httpd.minspareservers= 10 | bbconfig.unix.httpd.minspareservers= 10 | ||
| + | |||
bbconfig.unix.httpd.startservers= 50 | bbconfig.unix.httpd.startservers= 50 | ||
另外原廠也建議，如果之後使用上遇到java.long.OutOfMemory error，可以把bbconfig.max.heapsize.tomcat= 1024m 改成1280m 或是1536m | 另外原廠也建議，如果之後使用上遇到java.long.OutOfMemory error，可以把bbconfig.max.heapsize.tomcat= 1024m 改成1280m 或是1536m | ||
於 2008年5月13日 (二) 03:43 的最新修訂
Q: BB站台連線異常是的錯誤訊息ORA-00018: maximum number of sessions exceeded
A: 超出session最大值~可試試再增加oracle的process和session參數，經過討論 oracle process 改為500。
其他參數由原廠建議調校數據如下
I. Database changes
\*max number of semaphore identifiers:
set semsys:seminfo_semmni=50
\*
\*max number of semaphores per identifier:
\*semmsl=largest number of processes of all instances < 512
set semsys:seminfo_semmsl=500
\*
\*max number of semaphores: semmns=semmni*semmsl
\*semmns>=sum of all processes of all instances
\*semmns>=semmni*semmsl
set semsys:seminfo_semmns=25000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
II. Appserver changes
\*********************
bbconfig.unix.httpd.maxclients= 200
bbconfig.appserver.maxthreads= 200
bbconfig.database.bb_60.db.maxpoolsize= 200
bbconfig.database.bb_60.db.minpoolsize= 50
bbconfig.max.heapsize.tomcat= 1024m
bbconfig.min.heapsize.tomcat= 512m
bbconfig.unix.modperl.keepalive= Off
bbconfig.unix.modperl.maxclients= 20
bbconfig.unix.modperl.maxspareservers= 10
bbconfig.unix.modperl.minspareservers= 3 (or 5)
bbconfig.unix.modperl.startservers= 10
bbconfig.unix.httpd.maxspareservers= 50
bbconfig.unix.httpd.minspareservers= 10
bbconfig.unix.httpd.startservers= 50
另外原廠也建議，如果之後使用上遇到java.long.OutOfMemory error，可以把bbconfig.max.heapsize.tomcat= 1024m 改成1280m 或是1536m
