5.2.2 Administering Database Resource Management

To set up database resource management, you must use Oracle Database Resource Manager to configure the consumer groups, assign sessions to consumer groups, create a database resource plan, and enable the plan.

• Setting Up Consumer Groups and Categories
  Consumer groups and categories are set up with the procedures in the PL/SQL DBMS_RESOURCE_MANAGER package.
• Assigning Sessions to Consumer Groups
  You can assign a session to a resource consumer group manually or automatically using consumer group mapping rules.
• Creating a CDB Plan
  The CDB plan manages CPU resources on the database servers, and flash cache space and I/O bandwidth on the Exadata storage servers.
• Creating a Database Plan
  Database resource plans, also known as intradatabase plans, are created using the PL/SQL procedures DBMS_RESOURCE_MANAGER.CREATE_PLAN() and CREATE_PLAN_DIRECTIVE().
• Enabling a Database Resource Plan
  You can manually enable database resource plans by setting the RESOURCE_MANAGER_PLAN parameter. You can automatically enable resource plans by defining an Oracle Scheduler window with a resource plan.
• Managing Fast File Creation
  Oracle Exadata System Software features fast file creation, allowing accelerated initialization of data files.
• Managing Data Import
  You can control the priority of ETL as well as the amount of I/O resources that ETL consumes using I/O Resource Management (IORM).
• Managing Oracle Recovery Manager Backups and Copies
  You can use I/O Resource Management (IORM) to control the resource consumption and priority of RMAN I/Os.