oracle 11g管理篇

26 Managing Automated Database Maintenance Tasks

About Automated Maintenance Tasks..............................................................................................26-1 About Maintenance Windows ...........................................................................................................26-2 Configuring Automated Maintenance Tasks...................................................................................26-3 Enabling and Disabling Maintenance Tasks for all Maintenance Windows..........................26-3 Enabling and Disabling Maintenance Tasks for Specific Maintenance Windows................26-4 Configuring Maintenance Windows.................................................................................................26-4 Modifying a Maintenance Window..............................................................................................26-4 Creating a New Maintenance Window.......................................................................................26-4 Removing a Maintenance Window..............................................................................................26-5 Configuring Resource Allocations for Automated Maintenance Tasks.....................................26-5 About Resource Allocations for Automated Maintenance Tasks............................................26-6 Changing Resource Allocations for Automated Maintenance Tasks......................................26-6 Automated Maintenance Tasks Reference.......................................................................................26-7 Predefined Maintenance Windows..............................................................................................26-7 Automated Maintenance Tasks Database Dictionary Views....................................................26-7 27Managing Resources with Oracle Database Resource Manager

About Oracle Database Resource Manager......................................................................................27-1 What Solutions Does the Resource Manager Provide for Workload Management?............27-2 Elements of the Resource Manager..............................................................................................27-3 About Resource Manager Administration Privileges................................................................27-6 Assigning Sessions to Resource Consumer Groups.......................................................................27-7 Overview of Assigning Sessions to Resource Consumer Groups...........................................27-7 Assigning an Initial Resource Consumer Group........................................................................27-8 Specifying Session-to–Consumer Group Mapping Rules.........................................................27-8 Switching Resource Consumer Groups.....................................................................................27-12 Specifying Automatic Resource Consumer Group Switching...............................................27-14 Granting and Revoking the Switch Privilege............................................................................27-16 The Types of Resources Managed by the Resource Manager....................................................27-17 CPU.................................................................................................................................................27-18 Degree of Parallelism Limit.........................................................................................................27-20 Parallel Target Percentage...........................................................................................................27-20 Parallel Queue Timeout................................................................................................................27-22 Active Session Pool with Queuing.............................................................................................27-23 Automatic Consumer Group Switching....................................................................................27-23 Canceling SQL and Terminating Sessions.................................................................................27-23 Execution Time Limit...................................................................................................................27-23 Undo Pool.......................................................................................................................................27-23 Idle Time Limit..............................................................................................................................27-24 Creating a Simple Resource Plan ....................................................................................................27-24 Creating a Complex Resource Plan..................................................................................................27-25 About the Pending Area..............................................................................................................27-26 Creating a Pending Area..............................................................................................................27-26 Creating Resource Consumer Groups ......................................................................................27-27 Creating a Resource Plan.............................................................................................................27-27 Creating Resource Plan Directives ............................................................................................27-28 xx