OraFAQ Forum: Networking and Gateways » Shared Server OR Dedicated Server

Home » RDBMS Server » Networking and Gateways » Shared Server OR Dedicated Server (Oracle 10g Release 2.)

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

Shared Server OR Dedicated Server [message #542361]

Mon, 06 February 2012 21:18

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi All,

I've below questions about my raised topic.

1. How would I know whether I'm running Shared Server or Dedicated Server?
2. How to configure Shared Server?
3. How to configure Dedicated Server?
4. How Can I use both these connection types with one database?
I mean one session with dedicated and one with shared at the same time.

Thanks & Regards
Manoj

Report message to a moderator

Re: Shared Server OR Dedicated Server [message #542362 is a reply to message #542361]

Mon, 06 February 2012 21:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

This really is a FAQ & GOOGLE is your friend!
The client specifies/decides whether to make dedicated or shared connection to DB Server.

Report message to a moderator

Re: Shared Server OR Dedicated Server [message #542388 is a reply to message #542361]

Tue, 07 February 2012 01:07

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Concepts

We don't do your homework.

Regards
Michel

Report message to a moderator

Re: Shared Server OR Dedicated Server [message #542398 is a reply to message #542388]

Tue, 07 February 2012 02:30

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

To be fair, I don't think there is a description of how to set up shared server in the docs, certainly not in the Concepts Guide. The Net Services Adminstration Guide gives a description of the theory http://docs.oracle.com/cd/E11882_01/network.112/e10836/net_arch.htm#i1046119 but no hint of how to configure it.
Manoj, you need to reat Net Services Admin Guide (all of it) and then go to the Reference http://docs.oracle.com/cd/E11882_01/server.112/e25513/toc.htm and read up on the parameters shared_servers and dispatchers and the views v$shared_server, v$dispatcher, v$shared_server_monitor, v$circuit, v$session and a few others. You'll be able to work out the join columns. You also need to read at least this http://docs.oracle.com/cd/E11882_01/network.112/e10835/tnsnames.htm#i454847 from the Net Reference.

Report message to a moderator

Re: Shared Server OR Dedicated Server [message #542405 is a reply to message #542398]

Tue, 07 February 2012 02:48

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I don't think there is a description of how to set up shared server in the docs

To set up, no, but to explain what it is, yes (chapter 9, Process Architecture, in 10.2 doc) with links to how to set it.

Regards
Michel

Report message to a moderator

Re: Shared Server OR Dedicated Server [message #542411 is a reply to message #542405]

Tue, 07 February 2012 03:10

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I guess it's time I read it again.....

Report message to a moderator

Previous Topic:	dblinks
Next Topic:	Performance difference between Windows PC and Windows on VMware

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 09:03:40 CST 2025