OCP 1Z0 053 267

267.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. 
Answer: D 

http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11868

SWITCH_IO_REQSSpecifies 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.

BEGIN  DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (   PLAN                => 'DAYTIME',   GROUP_OR_SUBPLAN    => 'OLTP',   COMMENT             => 'OLTP group',   MGMT_P1             => 75,   SWITCH_GROUP        => 'LOW_GROUP',   SWITCH_IO_REQS      => 10000,   SWITCH_IO_MEGABYTES => 2500,   SWITCH_FOR_CALL     => TRUE);END;/

SWITCH_GROUPSpecifies 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 isNULL.

If the group name is 'CANCEL_SQL', the SWITCH_FOR_CALL parameter is always set to TRUE, overriding the user-specified setting.

BEGIN  DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (   PLAN             => 'DAYTIME',   GROUP_OR_SUBPLAN => 'OLTP',   COMMENT          => 'OLTP group',   MGMT_P1          => 75,   SWITCH_GROUP     => 'KILL_SESSION',   SWITCH_TIME      => 60);END;/