OraFAQ Forum: Server Administration » How can I know MY server is in Shared Server Mode

Home » RDBMS Server » Server Administration » How can I know MY server is in Shared Server Mode

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

How can I know MY server is in Shared Server Mode [message #63390]

Fri, 01 October 2004 03:28

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

Hi, Frends,

I have configured a shared server parameter.

but when i connected to the database and query "server" column of v$session view i found "dedicated" is a result..So How can i know the my server is in shared server mode.

Pl. Help me ...

BHavin

�

�

�

�

�

Report message to a moderator

Re: How can I know MY server is in Shared Server Mode [message #63391 is a reply to message #63390]

Fri, 01 October 2004 04:27

Deepak Panda
Messages: 24
Registered: May 2004

Junior Member

Even if you have configured your server for shared server connections, users can also request dedicated server connections.

Report message to a moderator

Re: How can I know MY server is in Shared Server Mode [message #63392 is a reply to message #63391]

Fri, 01 October 2004 05:14

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

hi deepak,

But how can user will request for dedicated mode..

but if they will not reqest they how can i assure that my oracle server is in shared server

bhavin

Report message to a moderator

Re: How can I know MY server is in Shared Server Mode [message #63397 is a reply to message #63392]

Fri, 01 October 2004 07:06

croK
Messages: 170
Registered: April 2002

Senior Member

On unix machines you can ps -ef&#124more
an you can see additional unix process like
*S000*
*S001*
*S002*

asteriks means i dont remember the exact name
'S' stands for SHARED.

I also think you can query dicctionary views like
V$SHARED_SERVER

Best luck.
Oracle Consultant and remote DBA for hire.

Report message to a moderator

Re: How can I know MY server is in Shared Server Mode [message #63405 is a reply to message #63392]

Sat, 02 October 2004 22:17

Sujit Sarkar
Messages: 40
Registered: September 2003

Member

Dear Bhavin,

when you configure TNSNAMES.ORA(Local Naming) at the client side specify two Net Service Name and specify (SERVER=SHARED) for Shared Server Connection and (SERVER=DEDICATED) for Dedicated Connection.

when you choose to connect to Database with the Net Service name for shared Serevr, you are connected to shared server mode and the other will be connected as Dedicated Server Mode.

Also Note that all the Database Administration jobs can't be performed when you are connected in shared server mode for that your connection type must be Dedicated.

Sujit

Report message to a moderator