BB站台連線異常

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