| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle the best
Hi,
It is not running in MTS mode. Our DBA tried to configure the database for MTS mode. But he could not do it. Can anyone tell the steps to follow to configure Oracle for MTS?
Regards,
Prasad BAV.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, November 09, 2001 8:50 PM
> 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: bavprasad_oracle_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: Maheswara.Rao_at_Sungardp3.com
>
> 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: ListGuru_at_fatcity.com (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: Prasad BAV INET: bavprasad_oracle_at_yahoo.com 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: ListGuru_at_fatcity.com (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).Received on Mon Nov 12 2001 - 11:21:02 CST
 |
 |