Oracle
1Z0-050 · Question #89
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution…
The correct answer is D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP. See the full explanation below for the reasoning.
Question
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?
Options
- ASet a threshold for the default system-defined moving window baseline.
- BAdd directives to the Automatic Database Diagnostic Monitor (ADDM).
- CModify the profile for the targeted users for which control needs to be imposed.
- DImplement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP
How the community answered
(45 responses)- A11% (5)
- B2% (1)
- C4% (2)
- D82% (37)
Community Discussion
No community discussion yet for this question.