Home » RDBMS Server » Networking and Gateways » Shared Server OR Dedicated Server (Oracle 10g Release 2.)
Shared Server OR Dedicated Server [message #542361] Mon, 06 February 2012 21:18 Go to next message
Manoj.Gupta.91
Messages: 186
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
Re: Shared Server OR Dedicated Server [message #542362 is a reply to message #542361] Mon, 06 February 2012 21:22 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
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.
Re: Shared Server OR Dedicated Server [message #542388 is a reply to message #542361] Tue, 07 February 2012 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 57604
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts

We don't do your homework.

Regards
Michel
Re: Shared Server OR Dedicated Server [message #542398 is a reply to message #542388] Tue, 07 February 2012 02:30 Go to previous messageGo to next message
John Watson
Messages: 4081
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.

Re: Shared Server OR Dedicated Server [message #542405 is a reply to message #542398] Tue, 07 February 2012 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 57604
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Shared Server OR Dedicated Server [message #542411 is a reply to message #542405] Tue, 07 February 2012 03:10 Go to previous message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
I guess it's time I read it again.....
Previous Topic: dblinks
Next Topic: Performance difference between Windows PC and Windows on VMware
Goto Forum:
  


Current Time: Thu Apr 17 00:54:07 CDT 2014

Total time taken to generate the page: 0.09112 seconds