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: [EMAIL PROTECTED] > > 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: [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.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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).
