OCP CBT Question 687

Please solve the following question.

A database instance is configured to use the `DEFAULT_MAINTENANCE_PLAN` during the maintenance window (e.g., for nightly backups and statistics gathering). You notice that during this window, some critical batch jobs (assigned to `BATCH_GROUP`) are running very slowly, even though the maintenance activities are not particularly CPU-intensive. You examine `V$RSRC_PLAN` and `V$RSRC_CONSUMER_GROUP` and see that `DEFAULT_MAINTENANCE_PLAN` is active. Which configuration issue is most likely causing the `BATCH_GROUP` to run slowly?

Relevant Directives from DEFAULT_MAINTENANCE_PLAN
-- Directives for DEFAULT_MAINTENANCE_PLAN
PLAN_NAME             GROUP_OR_SUBPLAN      MGMT_P1  MGMT_P2  PARALLEL_DEGREE_LIMIT_P1
--------------------- --------------------- -------- -------- ------------------------
DEFAULT_MAINTENANCE_PLAN  SYS_GROUP                 100        
DEFAULT_MAINTENANCE_PLAN  AUTO_TASK_CONSUMER_GROUP    80        
DEFAULT_MAINTENANCE_PLAN  BATCH_GROUP               10       20
DEFAULT_MAINTENANCE_PLAN  OTHER_GROUPS              0        0

Current Database State

RESOURCE_MANAGER_PLAN parameter is set to DEFAULT_MAINTENANCE_PLAN.
No other explicit session switches are occurring for BATCH_GROUP.

The AUTO_TASK_CONSUMER_GROUP is consuming all available CPU resources, leaving insufficient resources for BATCH_GROUP.

The BATCH_GROUP directive's MGMT_P1 value is too low, limiting its CPU allocation at the primary level.

The PARALLEL_DEGREE_LIMIT_P1 for BATCH_GROUP is set too low, preventing parallel queries from utilizing full resources.

The DEFAULT_MAINTENANCE_PLAN is configured to only allow SYS_GROUP to use significant resources, starving other groups.