Prev Question
Next 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?

Set a threshold for the default system-defined moving window baseline.

Add directives to the Automatic Database Diagnostic Monitor (ADDM).

Modify the profile for the targeted users for which control needs to be imposed.

Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP

Prev Question
Next Question

Leave a Reply

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