DEDICATED or MULTI-THREADED

[RamHardikar]

hi,

how can i know if my oracle server is configured as a 'DEDICATED SERVER' or 'MULTI-THREADED SERVER' ?

 

[nwardez]

Hi,

Have a look at your $ORACLE_HOME/dbs/init<sid>.ora
If your Oracle instance runs in multi-threaded, you should find lines beginning with

mts_dispatcher=

uncommented.

DEDICATED or MULTI-THREADED doesn't depend on your server, but on each of your instances.

 

[RamHardikar]

hi,

the parameter 'mts_dispatcher' (uncommented) is present in the init<sid>.ora file. so i can say that my oracle instance is configured for multi-threaded. thatz good.

so does that mean MTS is the default setting ? if i comment the line starting with 'mts_dispatcher', and restart my oracle instance, will it run as a dedicated server ?

 

[nwardez]

Yes, your instance will (should ?, uncomment the line if it goes down) restart in DEDICATED mode

If you're running on an Unix server, you should then decrease the SGA size of your instance, because in that case, each connection will generate a new process, and each new process will have its own PGA and UGA in memory, whereas this memory is taken in SGA in MULTI-THREADED (sizing is quite different under Windows because Oracle generate threads - and no processes -, but I'm not really familiar with it ...).

On a server with few memory, this could be quite dangerous if many users get connected and there's no way to regulate it: you can't help &quot;Oracle&quot; growing in memory

I don't know if it's the default parameter when you create a new instance, but you can specify it using dbassist.

 

[Turkbear]

Hi,
Just having that line uncommented will use some default values for the MTS stuff..
Look at the docs about how to specify the number of dispatchers, servers, etc..
search at

http://tahiti.oracle.com

for MTS

Also, be sure to read up on setting the sqlnet.ora file so that you can perform DBA work..You must connect on a DEDICATED connection to do most DBA tasks...

 

[RamHardikar]

thanks for ur replies.

what i have observed is MTS is by default as i cud see the MTS_DISPATCHERS option in init<sid>.ora file. i hv not tried commenting this option and tried restarting the oracle instance to see the dedicated server. will try that out soon.

i hv few other questions for which i'll start a new thread.

 

[RamHardikar]

hi,

i cud see 2 entries for 'mts_dispatchers' in init<sid>.ora

1. mts_dispatchers = (protocol=TCP)(pre=oracle.aurora.server.SGiopServer)

2. mts_dispatchers = (protocol=TCP)

which one should i comment?

and my oracle is running on NT.