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/SQLDBMS_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 proceduresDBMS_RESOURCE_MANAGER.CREATE_PLAN()
andCREATE_PLAN_DIRECTIVE()
. - Enabling a Database Resource Plan
You can manually enable database resource plans by setting theRESOURCE_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.
Parent topic: Administering IORM