- You might want to consider using orastack.exe to reduce the memory requirements. By default, every thread (oracle,tns, svrmgrl, sqlplus) takes 1M. That is more than enough of stack space. I would reduce it to 500K using the orastack.exe.
- In addition to this, you may reduce your SGA to a convenient size. - Look into 4GT tuning. This will allow oracle to use memory beyond 2G limitation (incl SGA+PGA ..) - What are the sort area settings that you have? > > -----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!? > Get your free @yahoo.com address at http://mail.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: > 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: Srinagesh Battula 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).