Home » RDBMS Server » Server Administration » How to find out my oracle9i run in mts mode/dedicated mode?
How to find out my oracle9i run in mts mode/dedicated mode? [message #201220] Fri, 03 November 2006 02:53 Go to next message
Tom_webex
Messages: 13
Registered: July 2006
Location: China
Junior Member
I have a oracle9.2.0 db server,how can I find out my oracle run in mts mode/dedicated mode?
Thanks!

Report message to a moderator

Re: How to find out my oracle9i run in mts mode/dedicated mode? [message #201381 is a reply to message #201220] Fri, 03 November 2006 18:34 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Hmmm... you can tell if a session runs in MTS or dedicated mode in the "server" column of v$session. An MTS (shared server mode) enabled instance can run dedicated mode sessions (internal sessions are always dedicated from what I recall).

Report message to a moderator

Re: How to find out my oracle9i run in mts mode/dedicated mode? [message #201384 is a reply to message #201381] Fri, 03 November 2006 18:55 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7811879860826

Report message to a moderator

Previous Topic: ORA-12526
Next Topic: dedicated or shared server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:38:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.