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




Reply With Quote