Database Resource Manager in the Oracle 10g database

Database Resource Manager in the Oracle 10g database

Oracle Database 10g introduces new features to the Resource Manager for managing your resources.  For example: if you want the PMON process kills sessions that are idle for longer than 600 seconds and kills sessions that are idle for more than 300 seconds and are blocking other sessions, then you should use the DBMS_RESOURCE_MANAGER package. We assumed that you have already defined your plan as ‘MY_DAY_PLAN’ and your group as ‘MY_FIRST_GROUP.’

SQL> BEGIN

            DBMS_RESOURCE_MANAGER.create_plan_directive (

            PLAN                                       =>            ‘MY_DAY_PLAN’,

            GROUP_OR_SUBPLAN            =>            ‘MY_FIRST_GROUP’,

            COMMET                                =>            ‘Limit user idle time’,

            MAX_IDLE_TIME                    =>            600,

            MAX_IDLE_BLOCKER_TIME   =>            300);

         END;

         /