-
How could I know if the database is in Multi-Threaded Server mode, by querying dictionary view?
Queyon
Queyon Zeng
-
server column in v$session show up as "SHARED' if MTS enabled otherwise show 'DEDICATED'
Reddy,Sam
-
MTS
But I checked the "server" column in V$SESSION, it's different from it shows in database configuration assistant.
Queyon
Queyon Zeng
-
Select * from v$shared_server must show some records.
Also other tables like v$dispatcher will have records.
Sridhar R Patnam
-
look for "mts%" in v$parameter
Jeff Hunter
-
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.
-
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.
-
Sure, but the question was "is my db in MTS", not "does x session use MTS".
Jeff Hunter
-
Exactly Jeff,
So Sam's reply to check v$session view can be deceiving depending on where you're issuing the command from.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|