Resource Manager is an Enterprise Edition feature that provides a set of PL/SQL APIs that allow the DBA to assign a priority to sessions, making sure that the most important transactions get the major share of system resources.
please refer to following link for this wonderful utility:
http://docs.oracle.com/cd/F49540_01/DOC/server.815/a68001/dbms_res.htm
The DBMS_RESOURCE_MANAGER package is used to administer the new resource plan and consumer group options in Oracle. The package contains several procedures that are used to create, modify, drop and grant access to resource plans, groups, directives and pending areas. The invoker must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute these procedures. The procedures to grant and revoke this privilege are in the package DBMS_RESOURCE_MANAGER_PRIVS.
please refer to following link for this wonderful utility:
http://docs.oracle.com/cd/F49540_01/DOC/server.815/a68001/dbms_res.htm
Comments
Post a Comment