OraFAQ Forum: Server Administration » How to find out my oracle9i run in mts mode/dedicated mode?

Home » RDBMS Server » Server Administration » How to find out my oracle9i run in mts mode/dedicated mode?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find out my oracle9i run in mts mode/dedicated mode? [message #201220]

Fri, 03 November 2006 02:53

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 15 17:49:34 CDT 2026