Multi-threaded server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Multi-threaded server

  1. #1

    Smile

    How could I know if the database is in Multi-Threaded Server mode, by querying dictionary view?

    Queyon
    Queyon Zeng

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    server column in v$session show up as "SHARED' if MTS enabled otherwise show 'DEDICATED'
    Reddy,Sam

  3. #3

    Angry MTS

    But I checked the "server" column in V$SESSION, it's different from it shows in database configuration assistant.

    Queyon
    Queyon Zeng

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Select * from v$shared_server must show some records.
    Also other tables like v$dispatcher will have records.
    Sridhar R Patnam

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    look for "mts%" in v$parameter
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Try..
    Show parameter mts
    you will get...as below..SQL> show parameter mts

    NAME TYPE VALUE
    ------------------------------------ ------- ------------------------------
    mts_circuits integer 0
    mts_dispatchers string
    mts_listener_address string
    mts_max_dispatchers integer 5
    mts_max_servers integer 20
    mts_multiple_listeners boolean FALSE
    mts_servers integer 0
    mts_service string ABCD
    mts_sessions integer 0
    SQL>
    Thanks.
    Thanigaivasan.

  7. #7
    Join Date
    Jan 2001
    Posts
    30
    Isn't it true with MTS, a database may be defined as to use MTS, but an individual session can either be Dedicated or shared based on the client Tnsnames.ora entry for the database.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, but the question was "is my db in MTS", not "does x session use MTS".
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Jan 2001
    Posts
    30
    Exactly Jeff,
    So Sam's reply to check v$session view can be deceiving depending on where you're issuing the command from.

  10. #10
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by sreddy
    server column in v$session show up as "SHARED' if MTS enabled otherwise show 'DEDICATED'
    So, I have to correct it and I'm...

    Server column in v$session show up as "SHARED' if any of the datbase sessions use MTS, otherwise show up 'DEDICATED'. Rest of the checks (to see MTS is enabled ) as posted by others...

    Thats was Quick thought I got, assuming database will be using MTS if enabled...on purpose.
    Reddy,Sam

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