![](https://csdnimg.cn/release/download_crawler_static/6625101/bg14.jpg)
xx
Manually Switching Resource Consumer Groups................................................................... 26-22
Specifying Automatic Resource Consumer Group Switching ............................................... 26-23
Specifying Session-to–Consumer Group Mapping Rules....................................................... 26-25
Enabling Users or Applications to Manually Switch Consumer Groups............................. 26-29
Granting and Revoking the Switch Privilege............................................................................ 26-30
Enabling Oracle Database Resource Manager and Switching Plans........................................ 26-32
Putting It All Together: Oracle Database Resource Manager Examples .................................. 26-33
Multilevel Plan Example.............................................................................................................. 26-34
Examples of Using the Maximum Utilization Limit Attribute............................................... 26-36
Example of Using Several Resource Allocation Methods....................................................... 26-39
An Oracle-Supplied Mixed Workload Plan .............................................................................. 26-39
Managing Multiple Database Instances on a Single Server....................................................... 26-40
About Instance Caging................................................................................................................. 26-40
Enabling Instance Caging ............................................................................................................ 26-41
Maintaining Consumer Groups, Plans, and Directives............................................................... 26-42
Updating a Consumer Group...................................................................................................... 26-42
Deleting a Consumer Group ....................................................................................................... 26-42
Updating a Plan............................................................................................................................. 26-42
Deleting a Plan............................................................................................................................... 26-43
Updating a Resource Plan Directive .......................................................................................... 26-43
Deleting a Resource Plan Directive ............................................................................................ 26-44
Viewing Database Resource Manager Configuration and Status ............................................. 26-44
Viewing Consumer Groups Granted to Users or Roles .......................................................... 26-44
Viewing Plan Information ........................................................................................................... 26-44
Viewing Current Consumer Groups for Sessions.................................................................... 26-45
Viewing the Currently Active Plans........................................................................................... 26-45
Monitoring Oracle Database Resource Manager.......................................................................... 26-45
Interacting with Operating-System Resource Control ................................................................ 26-48
Guidelines for Using Operating-System Resource Control.................................................... 26-48
Oracle Database Resource Manager Reference............................................................................. 26-49
Predefined Resource Plans and Consumer Groups................................................................. 26-49
Predefined Consumer Group Mapping Rules.......................................................................... 26-51
Resource Manager Data Dictionary Views ............................................................................... 26-52
27 Oracle Scheduler Concepts
Overview of Oracle Scheduler............................................................................................................ 27-1
About Jobs and Supporting Scheduler Objects .............................................................................. 27-3
Programs .......................................................................................................................................... 27-4
Schedules.......................................................................................................................................... 27-4
Jobs .................................................................................................................................................... 27-4
Destinations ..................................................................................................................................... 27-6
File Watchers.................................................................................................................................... 27-7
Credentials ....................................................................................................................................... 27-7
Chains ............................................................................................................................................... 27-7
Job Classes........................................................................................................................................ 27-9
Windows......................................................................................................................................... 27-10
Groups ............................................................................................................................................ 27-14