5.1.6 About Consumer Groups and Resource Plans

Oracle Exadata provides out-of-the-box consumer groups and resource plans specifically designed for data warehouses that use Oracle Exadata System Software.

These resource plans can be modified to suit the needs of your environment.

The following consumer groups are for data warehouses:

• ETL_GROUP: Consumer group for ETL (extract, transform, and load) jobs.
• DSS_GROUP: Consumer group for non-critical decision support system (DSS) queries.
• DSS_CRITICAL_GROUP: Consumer group for critical DSS queries.

The following resource plans are for data warehouses:

• DSS_PLAN Resource Plan
  The DSS_PLAN resource plan is designed for data warehouses that prioritize critical DSS queries over non-critical DSS queries and ETL jobs.
• ETL_CRITCAL_PLAN Resource Plan
  The ETL_CRITICAL_PLAN prioritizes ETL over DSS queries.