||Oracle Tips by Burleson
Oracle 10g Automated Shared Server Configuration
The new Automated Shared Server Configuration
feature provides additional flexibility if you are using two server
models. You can now easily switch between shared server and
dedicated server without having to start a dispatcher.
When the Oracle Database 10g shared server
(previously multi-threaded server or MTS) is configured and a client
connection request arrives while no dispatchers are registered, a
dedicated server process handles the request. To ensure that a
particular database server’s clients always connect to a dispatcher,
configure the connect_data section of the connect descriptor as
For example, using our test database instance:
When no dispatcher process is available to
service the requested connection, then the client connection request
is rejected when SERVER=shared is set.
If the database is configured for shared server
and a particular client requires a dedicated server, you can
configure the client to use a dedicated server in one of the
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: