Using the 10g Resource Manager to manage INACTIVE sessions

CREATE THE PLAN begin dbms_resource_manager.create_pending_area(); end; / begin dbms_resource_manager.create_plan( plan => 'TEST_PLAN', comment => 'Resource plan/method for Idle time kill sessions'); end; / CREATE THE CONSUMER GROUPS begin dbms_resource_manager.create_consumer_group( consumer_group => 'LONG_RUNNING', comment =>'Privileged Users'); dbms_resource_manager.create_consumer_group( consumer_group => 'SHORT_RUNNING', comment => 'Under Privileged Users'); end; / CREATE DIRECTIVES FOR THE PLAN Consumer Group LONG_RUNNING will […]