Home » RDBMS Server » Server Administration » Defaulting to Dedicated Server versus Shared Server (Linux Oracle 10g2)
Defaulting to Dedicated Server versus Shared Server [message #304806] Thu, 06 March 2008 15:55 Go to next message
josephbautista
Messages: 3
Registered: March 2008
Location: Pasadena, CA
Junior Member
Hi all,

I configured our database to handle both shared server requests and dedicated server requests. Is there a way on the server end to make sure that incoming client requests default to connecting to a dedicated server?

Right now the only way I know how to do this is to specify on the tnsnames.ora file of the client machine (SERVER=DEDICATED) for the tnsnames.ora's definition for our database, but there's got to be a way to do it on the server end.

Thanks in advance.

Joe
Re: Defaulting to Dedicated Server versus Shared Server [message #304844 is a reply to message #304806] Thu, 06 March 2008 22:03 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
If you want to force every incoming connection to use a dedicated server then set the parameter USE_DEDICATED_SERVER=ON in your sqlnet.ora file of your clients. This will force the listener to spawn a dedicated server for all network sessions. It does this by adding (SERVER=dedicated) to the CONNECT_DATA section of connect descriptors. Connections from your clients will be given dedicated servers, even if shared server is configured on server side.

If you want to force it on server side than disable shared servers.

Regards

Manjit Kumar [mkbhati]
Re: Defaulting to Dedicated Server versus Shared Server [message #304860 is a reply to message #304806] Fri, 07 March 2008 00:04 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a way on the server end to make sure that incoming client requests default to connecting to a dedicated server?

Set max_dispatchers and max_shared_servers to 0.

Regards
Michel
Previous Topic: Missing u0902000.sql file when upgrading?
Next Topic: ora-01001
Goto Forum:
  


Current Time: Fri Dec 09 21:20:40 CST 2016

Total time taken to generate the page: 0.12987 seconds