MTS or Dedicated

Hello Guys:

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

What are the views to see?

Thanks, ST2003

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

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

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

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

You are not running MTS from show parameter command.