Oracle
1Z0-054 · Question #25
You use the following query to monitor the Shared Servers: SQL>SELECT maximum_connections "MAX CONN", servers_started "STARTED", servers_terminated "TERMINATED", servers_highwater "HIGHWATER" FROM…
The correct answer is D. The number of Shared Servers is too low, so you should increase the number of Shared Servers. See the full explanation below for the reasoning.
Question
You use the following query to monitor the Shared Servers:
SQL>SELECT maximum_connections "MAX CONN", servers_started "STARTED", servers_terminated "TERMINATED", servers_highwater "HIGHWATER" FROM v$shared_server_monitor; MAX CONN STARTED TERMINATED HIGHWATER --------------- ---------- ---------------- ---------- 3 6 6 3 With every execution, you observe that the values of the STARTED and TERMINATED columns are growing quickly. What action would you take?
Options
- AThe number of Shared Server sessions is too high, so you should decrease the value of
- BThe number of Shared Servers is too high, so you should decrease the number of Shared
- CNo action is required because this growth is a normal behavior in a Shared Server environment.
- DThe number of Shared Servers is too low, so you should increase the number of Shared Servers.
How the community answered
(45 responses)- A2% (1)
- B4% (2)
- C11% (5)
- D82% (37)
Community Discussion
No community discussion yet for this question.