Hi Rao, No, it is not running in MTS mode. It is running in shared server mode.
Prasad BAV. --- "Rao, Maheswara" <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ 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).