Description Explanation: Answers A and C are correct. To decrease number of dispatchers used in MTS configuration, you need to configure MTS_DISPATCHERS parameter in you init.ora file and then restart the instance. You can also use the name=value syntax at the SQL prompt to dynamically change the number of dispatchers on your system, or to accomplish other reconfiguration tasks. Incorrect Answers: B is incorrect; you cannot decrease the number of dispatchers with the ALTER SESSION command. D is incorrect; parameter MTS_MAX_DISPATCHERS is set to a number represents the maximum number of dispatcher processes for all network protocols combined that can be started for the duration of an instance. It cannot be used to decrease the number of dispatchers running currently. E is incorrect; there is no MTS_MIN_DISPATCHERS parameter in Oracle.Update Date and Time 2018-03-07 13:02:58
|Question ID 21361|| |
The initial number of dispatchers is set to 50. Because of the load on the dispatcher processes the DBA needs
to decrease the number of dispatchers. Which two recommended procedures could be used? (Choose two)
|Option A|| |
Issue the ALTER SYSTEM command to remove dispatchers.
|Option B|| |
Issue the ALTER SESSION command to remove dispatchers.
|Option C|| |
Edit the MTS_DISPATCHERS parameter and bounce the database.
|Option D|| |
Edit the MTS_MAX_DISPATCHERS parameter and bounce the database.
|Option E|| |
Edit the MTS_MIN_DISPATCHERS parameter and bounce the database.
|Correct Answer|| A,C|