MTS mode [message #63816] |
Tue, 09 November 2004 20:44 |
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 |
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.
|
|
|