hi all, There is a performance issue in my service, It's a website, using HTML pages serve static contents and jsp+struts+hibernate(proxool for DB connection pool) for dynamic contents. If the connections are over 800, the service becomes quite unstable, some requests get rapid response, but some NOT. I have been tried Linux tools such as top/vmstat/free to analyze it, and I found that CPU/memory/IO are NOT the bottle-neck. And the problem is none of business of Oracle database, because that another application using this database works fine. ------------------------------- Key points: 1, The max connections that tomcat can handle? Your experiences are very appreciated. 2, Any tools to analyze the performance bottle-neck? 3, Any other suggestion? ------------------------------- Ok, this might be a complex problem to describe it clearly, the following lines may be useful. Hareware: Two Dell 6850 server, 4*3.1Ghz CPU, 8G memory. One for application, and the other for database(Oracle 10g) ----------------------- Software: OS: CentOS v4 apache-2.2.4+tomcat5.5.15 ------------------------------ Application configuration parameters: apache: <IfModule prefork.c> StartServers 100 MinSpareServers 100 MaxSpareServers 150 ServerLimit 10000 MaxClients 5000 MaxRequestsPerChild 0 </IfModule> ----------------------------- #httpd -l Compiled in modules: core.c mod_authn_file.c mod_authn_default.c mod_authz_host.c mod_authz_groupfile.c mod_authz_user.c mod_authz_default.c mod_auth_basic.c mod_include.c mod_filter.c mod_log_config.c mod_env.c mod_setenvif.c prefork.c http_core.c mod_mime.c mod_status.c mod_autoindex.c mod_asis.c mod_cgi.c mod_negotiation.c mod_dir.c mod_actions.c mod_userdir.c mod_alias.c mod_so.c
--------------------------- tomcat: <Connector port="8083" maxHttpHeaderSize="8192" maxThreads="2500" minSpareThreads="50" maxSpareThreads="100" enableLookups="false" redirectPort="8443" acceptCount="300" connectionTimeout="20000" disableUploadTimeout="true"/> tomcat max-mem: 1.5G ------------------------------ proxool: <house-keeping-sleep-time>90000</house-keeping-sleep-time> <prototype-count>20</prototype-count> <maximum-connection-count>450</maximum-connection-count> <minimum-connection-count>100</minimum-connection-count> ------------------ Thanks you guys.