5.1.6.2 ETL_CRITCAL_PLAN Resource Plan
The ETL_CRITICAL_PLAN prioritizes ETL over DSS queries.
In this plan, the SYS_GROUP group is given 75 percent of the bandwidth. The remaining bandwidth is divided between the other consumer groups in the ratios specified by the level 2 allocations. The ETL_GROUP and DSS_CRITICAL_GROUP groups have a higher allocation (35 percent) than the DSS_GROUP and BATCH_GROUP groups (10 percent).
Table 5-3 ETL_CRITICAL_PLAN Resource Plan for Data Warehouses
Consumer Group | Level 1 (%) | Level 2 (%) | Level 3 (%) | Level 4 (%) |
---|---|---|---|---|
SYS_GROUP |
75 |
not set |
not set |
not set |
DSS_CRITICAL_GROUP |
not set |
35 |
not set |
not set |
DSS_GROUP |
not set |
10 |
not set |
not set |
ETL_GROUP |
not set |
35 |
not set |
not set |
BATCH_GROUP |
not set |
10 |
not set |
not set |
ORA$DIAGNOSTICS |
not set |
3 |
not set |
not set |
ORA$AUTOTASK_SUB_PLAN |
not set |
3 |
not set |
not set |
OTHER_GROUPS |
not set |
3 |
not set |
not set |
Parent topic: About Consumer Groups and Resource Plans