asked on

Shared Server and Dedicated Server

I'm very fresher in Oracle DBA field.I'm using Oracle 8.1.7.Pls help me

SELECT STATUS,SERVER
FROM V$SESSION
WHERE AUDSID = USERENV('SESSIONID')

Above query returns "dedicate"

And there is no "server=dedicate" entry in tnsnames.ora in server.

And following entries are available while i ran "show parameter"

mts_service=smsora
mts_servers=1
mts_dispatchers=(PROTOCOL=TCP)(SER=MODOSE)
mts_max_dispatchers=5
mts_max_servers=20

SO I'M IN CONFUSION IF MY DATABSE SERVER IS IN DEDICATE OR SHARED SERVER CONFIGURED MODE.
.PLS ANSWER?

ASKER CERTIFIED SOLUTION

sathyagiri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

prasantkmohanty

ASKER

Neither in Server nor in client there is the entry of "dedicated or shared" in TNSNAMES.ORA file.I have mentioned the same in my question.pls answer.

MohanKNair

Check whether the server is MTS configured

select server, count(*) from v$session where username is not null GROUP BY server;

MohanKNair

The above query returns "shared" only when at least one user is connect as shared. Even if the Database is MTS, the client has the option to connect as shared or dedicated by editing tnsnames.ora file entry.

prasantkmohanty

ASKER

select server, count(*) from v$session where username is not null GROUP BY server;

Above query results like below:

DEDICATED -2
None-67
PSEUDO-10

sathyagiri

I think dedicated is the default mode if nothing is specified in your TNSNAMES.ora