Hi All,

How to find whether Database is running on MTS or Dedicated mode?
Does this query meand that database is on MTS.

SQL> select * from v$MTS;

MAXIMUM_CONNECTIONS MAXIMUM_SESSIONS SERVERS_STARTED SERVERS_TERMINATED
------------------- ---------------- --------------- ------------------
SERVERS_HIGHWATER
-----------------
8 5 0 0
1

Please help .

Regards
Vijay Kr. Singh

Oracle LazyDBA home page