MTS or Dedicated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: MTS or Dedicated

  1. #1
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68

    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

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    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

  3. #3
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68
    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

  4. #4
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    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

  5. #5
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68
    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

  6. #6
    Join Date
    Jun 2000
    Posts
    295
    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
  •  


Click Here to Expand Forum to Full Width