-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|