Re: Dedicated vs. MTS

Hi there,

It depends upon what sort of Middleware you use.

If the Middleware can prespawn multiple Database Dispatchers which dynamically adjust in number according to the Incoming traffic, then you dont need to have MTS at the Oracle end.

In this Case, Dedicated Server Configuration or PreSpawned Dedicated Servers would yield a better performance becos the Connections from the Middleware are prespawned and does not drastically vary.

On the Other hand, if the Middleware is not capable of doing this, then Most of the Web sessions(from my experience) are short and many. Having PreSpawned Dispatchers and Server Processes will definetely help in this case.

The Client Machines can always request a Dedicated Session even if the Server is operated in MTS mode( for eg for Content loading etc)

For the MTS activity , Check V$MTS , v$Shared_server , V$circuit ,v$DISPATCHER etc . This will tell you if you need to Spawn more Dispatchers or Server processes or if they are idle , consuming too much of Memory..

You need to Check System's Memory usage before deciding to stick with Dedicated Servers..

Hope this helps..

-Thiru
NetComrade wrote:

> Hi folks,
>
> Can somebody give me some directive on what kind of config to use with
> web sites? Also, how do I make the DB use MTS? b/c it seems like it's
> on but not used:
>
> $ lsnrctl services
>
> LSNRCTL for Solaris: Version 2.3.4.0.0 - Production on 02-AUG-99
> 10:53:04
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DBLP2))
> Services Summary...
> DBLP2 has 2 service handler(s)
> DEDICATED SERVER established:55279 refused:0
> DISPATCHER established:0 refused:0 current:0 max:115 state:ready
> D000 (machine: lakeplacid2, pid: 1044)
> (ADDRESS=(PROTOCOL=ipc)(DEV=16)(KEY=#1044.1))
> The command completed successfully
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Mon Aug 02 1999 - 11:22:33 CDT