Which statement describes a solution to the above?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Magwai

Magwai

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.