Multi-threaded server

[Queyon]

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

Queyon

[sreddy]

server column in v$session show up as "SHARED' if MTS enabled otherwise show 'DEDICATED'

[Queyon]

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

Queyon

[patnams]

Select * from v$shared_server must show some records.
Also other tables like v$dispatcher will have records.

[marist89]

look for "mts%" in v$parameter

[thanigai]

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.

[mvander]

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.

[marist89]

Sure, but the question was "is my db in MTS", not "does x session use MTS".

[mvander]

Exactly Jeff,
So Sam's reply to check v$session view can be deceiving depending on where you're issuing the command from.

[sreddy]

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.