Database Resource Manager on 11gR2

Creating a plan that kill session if this session exceeds the CPU limit specified:

begin

dbms_resource_manager.create_plan_directive(plan => 'HIGH',
switch_estimate => TRUE,
group_or_subplan => 'oltp_pl',
mgmt_p1 => 85,
switch_group => 'kill_session',
switch_time => 50);
end;


When the session exceeds 50 seconds of CPU usage time, the session is killed.