Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » MaxClients Issue on Oracle 9iAS
MaxClients Issue on Oracle 9iAS [message #233533] Thu, 26 April 2007 08:23 Go to next message
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 #237158 is a reply to message #233533] Sat, 12 May 2007 14:40 Go to previous messageGo to next message
zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan
Senior Member

9iAS Version please? and Which Oracle patches has installed? and I could understand about the Database Connection??? U said HTTP connections and what is that Database???/

Zeeshan Ali AWan
zesh@inbox.com
Re: MaxClients Issue on Oracle 9iAS [message #237806 is a reply to message #233533] Tue, 15 May 2007 14:10 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Setting up Tomcat with Oracle
Next Topic: Application Server problem
Goto Forum:
  


Current Time: Tue Dec 06 06:24:37 CST 2016

Total time taken to generate the page: 0.06475 seconds