| MaxClients Issue on Oracle 9iAS [message #233533] |
Thu, 26 April 2007 08:23  |
syedashfaq2
Messages: 12
Registered: July 2005
Location: India
|
Junior Member |
|
|
Hi Experts,
We are facing a performance issue with one of our web application which is built using mod_plsql and hosted on Oracle 9iAS on HP-UNIX box and Oracle Database 9i on another HP-UNIX Box.
We had MaxClients value as 150 and with this setting the web application was working fine but since couple of months, there are performance issues when httpd processes reaches the MaxClients limit and there are about 90 ACTIVE concurrent Database sessions.
When we restart the Oracle Apps Server, it clears up httpd processed and web application looks fine for some time, and then gradually hits the MaxClients limit again.
We increased MaxClients to 300 but still the same problem persists with concurrent Database connections reaching 120.
Would you please advice what needs to be done further to improve the performance?
Thanks in Advance,
SA
|
|
|
|
|
|
| Re: MaxClients Issue on Oracle 9iAS [message #237806 is a reply to message #233533] |
Tue, 15 May 2007 14:10  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
9ias uses connection pooling. The size of the connection pool should probably be sized based on the peak number of "ACTIVE" database sessions.
select USER_NAME, PROGRAM, STATUS, count(*)
from v$session
group by USER_NAME, PROGRAM, STATUS
many active sessions means lots of clicks or just slow/intensive processing.
|
|
|
|
| Re: MaxClients Issue on Oracle 9iAS [message #237839 is a reply to message #233533] |
Tue, 15 May 2007 23:22 |
zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan
|
Senior Member |
|
|
Http shipped with Oracle 9i has a congifuration file in $OH/Apache/Apache/conf/httpd.conf. Please make a copy of that file as backup b4 doing any change in it. There is a flag in Global environment as
MaxKeepAliveRequest=100 change it as per ur requirement. and also increase the MaxClient flag.
Thanx
Zeeshan Ali Awan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
