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?
prasantkmohantyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sathyagiriConnect With a Mentor Commented:
Look at your client m/c's TNSNAMES.ORA and check if the SERVER is set to DEDICATED OR SHARED?

IF the server paramater in TNSNAMES is set to DEDICATED, then it will created a DEDICATED connection
0
 
prasantkmohantyAuthor Commented:
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.
0
 
MohanKNairCommented:
Check whether the server is MTS configured

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

0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
MohanKNairCommented:
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.
0
 
prasantkmohantyAuthor Commented:
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

0
 
sathyagiriCommented:
I think dedicated is the default mode if nothing is specified in your TNSNAMES.ora
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.