Oracle
1Z0-054 · Question #128
While tuning the shared server in your database, you executed the following command: SQL> ALTER SYSTEM SET DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=5)'; How does this statement affect the shared…
The correct answer is A. If there are currently less than five dispatchers, new dispatchers are created. B. If there are currently more than five dispatchers, additional dispatchers are terminated after the. See the full explanation below for the reasoning.
Question
While tuning the shared server in your database, you executed the following command:
SQL> ALTER SYSTEM SET DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=5)'; How does this statement affect the shared server configuration? (Choose two.)
Options
- AIf there are currently less than five dispatchers, new dispatchers are created.
- BIf there are currently more than five dispatchers, additional dispatchers are terminated after the
- CIf there are currently more than five dispatchers, Oracle server terminates additional dispatchers
- DIf there are currently less than five dispatchers, Oracle server terminates all of them and creates
How the community answered
(60 responses)- A73% (44)
- C20% (12)
- D7% (4)
Community Discussion
No community discussion yet for this question.