Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-threaded server

Re: Multi-threaded server

From: Heggelund <d92hegge_at_ix_prod.hfk.mil.no>
Date: 1997/04/23
Message-ID: <1997Apr23.073511.28685@ix_prod.hfk.mil.no>#1/1

Kelly Young (young_at_maricopa.edu) wrote:

: East Asian Library wrote:

: >
: > Hi netters. I heard different stories about mts. We have a system which
: > constantly hosts >800 oracle sessions (Solaris 2.5). Theses oracle
: > connections consumes lots of resource and we are wondering if oracle mts
: > can help us. We use oracle 7.1.6 with sqlnet (tcp/ip) 2.1.6.
: > Thanks in advance.
 
: From what I've been told, MTS should only be used "as a last resort".
: In your situation, with >800 users consuming "lots of resource", I
: would definitely consider using MTS.

--

MTS on Oracle versions previous to 7.3 can fragment your SGA severely. 
This might hurt performance. So test this thourogly. I've been told that this
problem is fixed in 7.3 but I have not tested that as I'm currently working
on a smaller project with no need for MTS. 

Rgds
Steinar Heggelund

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

My postings represent my opinions and they may be wrong. 
Received on Wed Apr 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US