iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 10g New Features

 

Database Resource Manager in the Oracle 10g database

 

‘An eye for eye only ends up making the whole world blind.’

Gandhi

 

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;

         /

 

 

Google
 
Web web site