Home » RDBMS Server » Server Administration » MTS mode
MTS mode [message #63816] Tue, 09 November 2004 20:44 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Hi All,

How can we know that a database is in MTS mode ?

How to change from MTS to dedicated and vise versa.

Hope you will please let us know.

TIA,

Jay

 

 
Re: MTS mode [message #63819 is a reply to message #63816] Wed, 10 November 2004 00:07 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Check the parameters MTS_DISPATCHERS & SHARED_SERVERS if it contains some non zero values so it means u r running in MTS. You can make dedicated connections in MTS using "SERVER=dedicated" parameter in your TNS entry. To completely switch to dedicated mode simply unset the above mentioned parameter and restart the database.

Daljit Singh.
Previous Topic: mls_date_format
Next Topic: Error in Export and Procedures and General Base
Goto Forum:
  


Current Time: Fri Sep 27 06:19:29 CDT 2024