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?
A.
Set a threshold for the default system-defined moving window baseline.
B.
Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C.
Modify the profile for the targeted users for which control needs to be imposed.
D.
Implement the database resource manager to add the SWITCH_IO_REQS and
SWITCH_GROUP directives.
D is correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm003.htm
SWITCH_GROUP Specifies the consumer group to which a session is switched if switch criteria are met. If the group name is ‘CANCEL_SQL’, then the current call is canceled when switch criteria are met. If the group name is ‘KILL_SESSION’, then the session is killed when switch criteria are met. Default is NULL.
SWITCH_IO_REQS Specifies the number of I/O requests that a session can execute before an action is taken. Default is UNLIMITED. The action is specified by SWITCH_GROUP.