administration guide 11g(20)

oracle 11g管理篇

Validating the Pending Area.......................................................................................................27-33 Submitting the Pending Area......................................................................................................27-34 Clearing the Pending Area..........................................................................................................27-35 Enabling Oracle Database Resource Manager and Switching Plans........................................27-35 Putting It All Together: Oracle Database Resource Manager Examples..................................27-37 Multilevel Plan Example..............................................................................................................27-37 Examples of Using the Maximum Utilization Limit Attribute...............................................27-39 Example of Using Several Resource Allocation Methods.......................................................27-45 Example of Managing Parallel Statements Using Directive Attributes................................27-45 An Oracle-Supplied Mixed Workload Plan..............................................................................27-47 Managing Multiple Database Instances on a Single Server.......................................................27-48 About Instance Caging.................................................................................................................27-48 Enabling Instance Caging............................................................................................................27-49 Maintaining Consumer Groups, Plans, and Directives...............................................................27-49 Updating a Consumer Group......................................................................................................27-50 Deleting a Consumer Group.......................................................................................................27-50 Updating a Plan.............................................................................................................................27-50 Deleting a Plan...............................................................................................................................27-50 Updating a Resource Plan Directive..........................................................................................27-51 Deleting a Resource Plan Directive............................................................................................27-51 Viewing Database Resource Manager Configuration and Status.............................................27-51 Viewing Consumer Groups Granted to Users or Roles..........................................................27-52 Viewing Plan Information...........................................................................................................27-52 Viewing Current Consumer Groups for Sessions....................................................................27-52 Viewing the Currently Active Plans...........................................................................................27-53 Monitoring Oracle Database Resource Manager..........................................................................27-53 Interacting with Operating-System Resource Control................................................................27-57 Guidelines for Using Operating-System Resource Control....................................................27-57 Oracle Database Resource Manager Reference.............................................................................27-58 Predefined Resource Plans and Consumer Groups.................................................................27-58 Predefined Consumer Group Mapping Rules..........................................................................27-60 Resource Manager Data Dictionary Views...............................................................................27-60 28 Oracle Scheduler Concepts

Overview of Oracle Scheduler............................................................................................................28-1 About Jobs and Supporting Scheduler Objects..............................................................................28-3 Programs..........................................................................................................................................28-4 Schedules..........................................................................................................................................28-4 Jobs....................................................................................................................................................28-5 Destinations.....................................................................................................................................28-6 File Watchers....................................................................................................................................28-7 Credentials.......................................................................................................................................28-7 Chains...............................................................................................................................................28-8 Job Classes......................................................................................................................................28-10 Windows.........................................................................................................................................28-11 Groups............................................................................................................................................28-14 More About Jobs..................................................................................................................................28-15

xxi