RE: Multi-threaded server - will it help in this case

I thought setting server=dedicated in the tnsnames.ora was the setting to change this

-----Original Message-----
Sent: Tuesday, November 11, 2003 4:29 PM To: Multiple recipients of list ORACLE-L

Tim,

This bit:

> accomodate this application. Please be aware that you can mix
> dedicated and MTS by setting up different TNS names on different ports
> for each, so it is not an all-or-nothing

seems to imply that MTS and Dedicated will each require their own listener ( different ports). Been awhile since I messed with MTS, but I don't recall that as being necessary.

Is that what you meant?

Jared

On Tue, 2003-11-11 at 07:04, Tim Gorman wrote:
> Peter,
>
> MTS (or SS in 9i onwards) is an excellent choice to accomodate this
> application. Please be aware that you can mix dedicated and MTS by
> setting up different TNS names on different ports for each, so it is
> not an all-or-nothing situation. Most connections to the database
> outside of this CAE app will likely be better served with dedicated
> connections, so just dole out TNS names accordingly.
>
> Also, please be sure to estimate the size of your UGA by tracking
> values (i.e. name like '%uga%') in V$SESSTAT at peak periods then
> sizing the Large Pool to accomodate, before you enable MTS. Unless
> you're really constrained for memory, don't be shy about this; double
> the highest value you sum from V$SESSSTAT to be safe. After enabling
> MTS, monitor the value of "free memory" where POOL = 'large pool'
> in V$SGASTAT. If you've oversized, you can start backing
> down on LARGE_POOL_SIZE gently, if you need the memory
> elsewhere...
>
> Hope this helps...
>
> -Tim
>
> > Environment: AIX 4.3
> > Oracle 8.1.7
> >
> > The application is a CAE tool which stores metadata for
> > a hierarchy of 3D engineering design models.
> > When a user opens a model at a given level in the design, the
> > application retrieves data about that model and all of the models
> > below it in the design try. This often involves as many as 100 or
> > more models. Unfortunately, the way the application is written, it
> > opens a new connection to the database for each model.
> > Thus, in the process of retrieving
> > metadata, it may open and close as many as 100 connections
> > to the database. Obviously, this causes some performance
> > problems, especially for remote users. The number of
> > users when the system goes fully into production
> > is going to be in the low 100's.
> >
> > The vendor is not interested in changing the way the software works.
> > Will use of the mult-threaded server improve performance
> > in this situation, for
> > example, by eliminating the overhead of starting a
> > dedicated server for each connection?
> >
> > Thanks,
> > Peter Schauss
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: tim_at_sagelogix.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).