MTS or Dedicated

[st2003]

Hello Guys:

What are the checks to make sure if the server is dedicated or shared?

What are the views to see?

Thanks, ST2003

[bhallar]

There are lots of ways to check MTS or dedicated,
1) Check the value of servers_highwatermark in v$mts table if greater than zero then u r running MTS.
2) Check if there any process with ora_SID_s00 or ora_SID_d00 (Server and Dispatcher)

HTH
Ravinder

[st2003]

SQL> show parameter server

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_server string
max_shared_servers integer 20
mts_max_servers integer 20
mts_servers integer 0
parallel_max_servers integer 5
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
rdbms_server_dn string
shared_server_sessions integer 0
shared_servers integer 0
SQL> select * from v$mts;

MAXIMUM_CONNECTIONS MAXIMUM_SESSIONS SERVERS_STARTED SERVERS_TERMINATED SERVERS_HIGHWATER
------------------- ---------------- --------------- ------------------ -----------------
0 0 0 0 0

SQL> select server, count(*) from v$session group by server;

SERVER COUNT(*)
--------- ----------
DEDICATED 54

Is this enough to determine that it is not MTS?

And what is connection pooling? Is it done at the OS level or DB level.

Thanks, ST2003

[bhallar]

Connection Pooling works when MTS is configured

Advantages
----------
1.Limits the number of network resources used per process.
2.Maximizes the number of client/server sessions over a limited number of physical connections.
3.Optimizes resource utilization.

Connection Pooling Recommended for: Networks where many clients run interactive "high think/search time" applications such as messaging and OLAP.

Above contents are from metalink docid Note:99713.1

HTH
Ravinder

[st2003]

Thanks..

For some reason, the dba I am working with says this database works with connection pooling and I concluded that it is MTS configured. But when I see the v$views, then it shows as dedicated? That's why I started having these questions. Please look at the result set I provided to determine if it's a MTS or dedicated?

ST2003

[sysdba]

You are not running MTS from show parameter command.