Prasad, Is the database running on MTS mode?
Rao -----Original Message----- Sent: Friday, November 09, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Hi, All of us believe Oracle is the best database server. We can keep our application data on Oracle and just forget the rest. I strongly believe I can do anything I want, with Oracle. We have a problem with Oracle. Ours is a small application with most hits. Lot of people will be using our solution and each hit results in database access. We have limitation on the maximum number of connections that can be made from Java application(servlet). We are accessing from 16 servlet machines to the database and making around 500 connections. We are using a connection pool from Javaexchange(DbConnectionBroker). When the application reaches beyond 500(I think the number is still less) connections, the database stops responding. Database machine's CPU usage goes 100%. And any requests from servlets at this point, will wait for a long time to get response from oracle. We are using Oracle 8.1.7, on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are using CLOB very frequently. Thanks in advance for your suggestion on tuning. Regards, Prasad BAV. __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
