MTS and Server Processes usage

[kgb]

Hi, guys
I was testing MTS which has following configuration:

mts_service = rcat
mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(mul=ON)(tick=4)(pool=(in=10)(out=10))(con=200)(sess=200)(HOST=10.0.0.77))(DI SPATCHERS=1)"
mts_max_dispatchers = 10
mts_servers = 15
mts_max_servers = 100
mts_listener_address = "(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.77)(PORT = 1555))"

I made several shared connections to database to check how shared servers are used. I executed several queries for each connection. And I had found that only one shared server process is in use.
My question are:
How Oracle determine which server process to use for new connection?
When Oracle spawn additional shared server processes up to mts_max_servers?


Thank you.






SQLWKS> SELECT * FROM V$SHARED_SERVER;
NAME PADDR STATUS MESSAGES BYTES BREAKS CIRCUIT IDLE BUSY REQUESTS
---- -------- ---------------- ---------- ---------- ---------- -------- ---------- ---------- ----------
S000 5449F6A0 EXEC 1793 1113547 0 54764CA8 208207 374 685
S001 5449F9BC WAIT(COMMON) 0 0 0 00 208337 0 0
S002 5449FCD8 WAIT(COMMON) 0 0 0 00 208333 0 0
S003 5449FFF4 WAIT(COMMON) 0 0 0 00 208329 0 0
S004 544A0310 WAIT(COMMON) 0 0 0 00 208324 0 0
S005 544A062C WAIT(COMMON) 0 0 0 00 208320 0 0
S006 544A0948 WAIT(COMMON) 0 0 0 00 208315 0 0
S007 544A0C64 WAIT(COMMON) 0 0 0 00 208311 0 0
S008 544A0F80 WAIT(COMMON) 0 0 0 00 208306 0 0
S009 544A129C WAIT(COMMON) 0 0 0 00 208302 0 0
10 rows selected.

SQLWKS> select * from v$circuit;
CIRCUIT DISPATCH SERVER WAITER SADDR STATUS QUEUE MESSAGE0 MESSAGE1 MESSAGE2 MESSAGE3 MESSAGES BYTES BREAKS PRESENTATION
-------- -------- -------- -------- -------- ---------------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------------
54764CA8 544A15B8 5449F6A0 00 544C2BF0 NORMAL SERVER 11 0 0 0 437 90476 0 TTC
54764DAC 544A15B8 00 00 544C4534 NORMAL NONE 0 0 0 0 766 581568 0 TTC
54764EB0 544A15B8 00 00 544C345C NORMAL NONE 0 0 0 0 159 118518 0 TTC
54764FB4 544A15B8 00 00 544C4DA0 NORMAL NONE 0 0 0 0 122 75843 0 TTC
547650B8 544A15B8 00 00 544C560C NORMAL NONE 0 0 0 0 112 61061 0 TTC
547651BC 544A15B8 00 00 544C5E78 NORMAL NONE 0 0 0 0 207 188288 0 TTC
6 rows selected.


[Edited by kgb on 03-23-2002 at 12:14 PM]

[sambavan]

The numbers that you have set for the initial server are kind of high to me you can initially start with 2 dispatchers and 5 servers. As the processes require more connection, oracle will spin more MTS proceses. Refer the Oracle Network guide on better undestanding the functionality of MTS. If you do "lsnrctl services", it will show you the max# of connections the dispatcher had been set to handle. You can also restrict this, by setting this option in the parameter field.

Remeber to have good amount of large_poo_size set, as every MTS process would consume roughly around 10M.

Sam