 |
|
Oracle Tips by Burleson |
Oracle 10g replaced parameters
All the replacement parameters listed in the
table are dynamic, meaning that you can change the values while the
instance is running. Table 9.1 shows the replaced parameters.
|
OBSOLETE PARAMETER |
REPLACED BY PARAMETER |
|
mts_servers |
shared_servers |
|
mts_max_servers |
max_shared_servers |
|
mts_dispatchers |
dispatchers |
|
mts_max-dispatchers |
max_dispatchers |
|
mts_circuits |
circuits |
|
mts_sessions |
shared_server_sessions |
|
mts_listener_address
mts_multiple_listeners |
local_listener |
Table 9.1 Oracle 10g Replacement Parameters
In the case of the dispatchers parameter, the
results of the change will depend on which attributes you modify.
Since several of the attributes affect the network session layer
when a dispatcher is started, they cannot be changed for dispatchers
already started. These attributes are: protocol, address,
description, presentation, connections, sessions, ticks, and
multiplex.
You can dynamically modify the other attributes
(listener and service) and affect existing as well as new
dispatchers of the same configuration.
There is a new view, v$dispatcher_config, that shows more information about existing dispatchers. This view
displays information about the dispatcher configurations, including
attributes that were not specified and were given a default value.
The column CONF_INDX in v$dispatcher_config can be joined to the
conf_indx column in"v$dispatcher to see all of
the detailed information about a given dispatcher. This information
helps you to make more informed decisions on what attributes to
modify and helps determine if you need to add or remove dispatchers.
For example, to get service and other details
about dispatchers, use the following query:
SQL> select name, dispatchers,
substr(service,1,20) service, idle, busy
Get the complete Oracle10g 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:
http://www.dba-oracle.com/service_oracle_backup.htm
|
