1460440.1 PXHCDR 11.4.5.8 Report: pxhcdr_orcl_rac1_11.2.0.4.0_20180125_164346_rscr.html

License   : N
RDBMS     : 11.2.0.4.0
Platform  : LINUX
Instance  : 1
CPU Count : 4
Block Size: 8192
OFE       : 11.2.0.4
DYN_SAMP  : 2
EBS       : ""
SIEBEL    : ""
PSFT      : ""
Date      : 2018-01-25/16:43:46

Default Resource Consumer Group and Profile per User

Collected from DBA_USERS.

# USERNAME INITIAL_RSRC_CONSUMER_GROUP PROFILE
1 ANONYMOUS DEFAULT_CONSUMER_GROUP DEFAULT
2 APEX_030200 DEFAULT_CONSUMER_GROUP DEFAULT
3 APEX_PUBLIC_USER DEFAULT_CONSUMER_GROUP DEFAULT
4 APPQOSSYS DEFAULT_CONSUMER_GROUP DEFAULT
5 BI DEFAULT_CONSUMER_GROUP DEFAULT
6 CTXSYS DEFAULT_CONSUMER_GROUP DEFAULT
7 DBSNMP DEFAULT_CONSUMER_GROUP MONITORING_PROFILE
8 DIP DEFAULT_CONSUMER_GROUP DEFAULT
9 EXFSYS DEFAULT_CONSUMER_GROUP DEFAULT
10 FLOWS_FILES DEFAULT_CONSUMER_GROUP DEFAULT
11 HR DEFAULT_CONSUMER_GROUP DEFAULT
12 IX DEFAULT_CONSUMER_GROUP DEFAULT
13 MDDATA DEFAULT_CONSUMER_GROUP DEFAULT
14 MDSYS DEFAULT_CONSUMER_GROUP DEFAULT
15 MGMT_VIEW DEFAULT_CONSUMER_GROUP DEFAULT
16 OE DEFAULT_CONSUMER_GROUP DEFAULT
17 OLAPSYS DEFAULT_CONSUMER_GROUP DEFAULT
18 ORACLE_OCM DEFAULT_CONSUMER_GROUP DEFAULT
19 ORDDATA DEFAULT_CONSUMER_GROUP DEFAULT
20 ORDPLUGINS DEFAULT_CONSUMER_GROUP DEFAULT
21 ORDSYS DEFAULT_CONSUMER_GROUP DEFAULT
22 OUTLN DEFAULT_CONSUMER_GROUP DEFAULT
23 OWBSYS DEFAULT_CONSUMER_GROUP DEFAULT
24 OWBSYS_AUDIT DEFAULT_CONSUMER_GROUP DEFAULT
25 PM DEFAULT_CONSUMER_GROUP DEFAULT
26 RYL DEFAULT_CONSUMER_GROUP DEFAULT
27 SCOTT DEFAULT_CONSUMER_GROUP DEFAULT
28 SH DEFAULT_CONSUMER_GROUP DEFAULT
29 SI_INFORMTN_SCHEMA DEFAULT_CONSUMER_GROUP DEFAULT
30 SPATIAL_CSW_ADMIN_USR DEFAULT_CONSUMER_GROUP DEFAULT
31 SPATIAL_WFS_ADMIN_USR DEFAULT_CONSUMER_GROUP DEFAULT
32 SYS SYS_GROUP DEFAULT
33 SYSMAN DEFAULT_CONSUMER_GROUP DEFAULT
34 SYSTEM SYS_GROUP DEFAULT
35 WMSYS DEFAULT_CONSUMER_GROUP DEFAULT
36 XDB DEFAULT_CONSUMER_GROUP DEFAULT
37 XS$NULL DEFAULT_CONSUMER_GROUP DEFAULT

Resource Profiles

Collected from DBA_PROFILES.

# PROFILE RESOURCE_NAME RESOURCE LIMIT
1 DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
2 DEFAULT CONNECT_TIME KERNEL UNLIMITED
3 DEFAULT CPU_PER_CALL KERNEL UNLIMITED
4 DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
5 DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
6 DEFAULT IDLE_TIME KERNEL UNLIMITED
7 DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
8 DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
9 DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
10 DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
11 DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
12 DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
13 DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
14 DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
15 DEFAULT PRIVATE_SGA KERNEL UNLIMITED
16 DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
17 MONITORING_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT
18 MONITORING_PROFILE CONNECT_TIME KERNEL DEFAULT
19 MONITORING_PROFILE CPU_PER_CALL KERNEL DEFAULT
20 MONITORING_PROFILE CPU_PER_SESSION KERNEL DEFAULT
21 MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
22 MONITORING_PROFILE IDLE_TIME KERNEL DEFAULT
23 MONITORING_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
24 MONITORING_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
25 MONITORING_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT
26 MONITORING_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT
27 MONITORING_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
28 MONITORING_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
29 MONITORING_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
30 MONITORING_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
31 MONITORING_PROFILE PRIVATE_SGA KERNEL DEFAULT
32 MONITORING_PROFILE SESSIONS_PER_USER KERNEL DEFAULT

Sessions per Resource Consumer Group

Collected from GV$SESSION.

# INST_ID TYPE USERNAME STATUS RESOURCE_CONSUMER_GROUP COUNT(*)
1 1 BACKGROUND   ACTIVE   34
2 1 USER SYS ACTIVE   1
3 1 USER   ACTIVE   5

Active Resource Plans

Collected from GV$RSRC_PLAN.

# INST_ID ID NAME IS_TO CPU INS PARALLEL_SERVERS_ACTIVE PARALLEL_SERVERS_TOTAL PARALLEL_EXECUTION_MANAGED
1 1 12876 INTERNAL_PLAN TRUE OFF OFF 0 64 FIFO

Active Resource Plans History

Collected from GV$RSRC_PLAN_HISTORY.

# INST_ID SEQUENCE# ID NAME START_TIME END_TIME ENABL WINDOW_NAME ALLOW CPU INS PARALLEL_EXECUTION_MANAGED
1 1 1     2018-01-25/15:36:26   FALSE   TRUE OFF OFF FIFO

Active Resource Consumer Groups

Collected from GV$RSRC_CONSUMER_GROUP.

# INST_ID NAME ID ACTIVE_SESSIONS EXECUTION_WAITERS REQUESTS CPU_WAIT_TIME CPU_WAITS CONSUMED_CPU_TIME YIELDS CPU_DECISIONS CPU_DECISIONS_EXCLUSIVE CPU_DECISIONS_WON QUEUE_LENGTH CURRENT_UNDO_CONSUMPTION ACTIVE_SESSION_LIMIT_HIT UNDO_LIMIT_HIT SWITCHES_IN_CPU_TIME SWITCHES_OUT_CPU_TIME SWITCHES_IN_IO_MEGABYTES SWITCHES_OUT_IO_MEGABYTES SWITCHES_IN_IO_REQUESTS SWITCHES_OUT_IO_REQUESTS SQL_CANCELED ACTIVE_SESSIONS_KILLED IDLE_SESSIONS_KILLED IDLE_BLKR_SESSIONS_KILLED QUEUED_TIME QUEUE_TIME_OUTS IO_SERVICE_TIME IO_SERVICE_WAITS SMALL_READ_MEGABYTES SMALL_WRITE_MEGABYTES LARGE_READ_MEGABYTES LARGE_WRITE_MEGABYTES SMALL_READ_REQUESTS SMALL_WRITE_REQUESTS LARGE_READ_REQUESTS LARGE_WRITE_REQUESTS CURRENT_PQS_ACTIVE CURRENT_PQ_SERVERS_ACTIVE PQS_QUEUED PQS_COMPLETED PQ_SERVERS_USED PQ_ACTIVE_TIME CURRENT_PQS_QUEUED PQ_QUEUED_TIME PQ_QUEUE_TIME_OUTS
1 1 OTHER_GROUPS 12889 1 0 156 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 1 _ORACLE_BACKGROUND_GROUP_ 0 38 0 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Active Resource Consumer Groups History

Collected from GV$RSRC_CONS_GROUP_HISTORY.

Resource Plans

Collected from DBA_RSRC_PLANS.

# PLAN_ID PLAN NUM_PLAN_DIRECTIVES CPU_METHOD MGMT_METHOD ACTIVE_SESS_POOL_MTH PARALLEL_DEGREE_LIMIT_MTH QUEUEING_MTH SUB COMMENTS STATUS MAN
1 12870 MIXED_WORKLOAD_PLAN 6 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Example plan for a mixed workload that prioritizes interactive operations over batch operations.   NO
2 12871 ORA$AUTOTASK_SUB_PLAN 3 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT YES Default sub-plan for automated maintenance tasks. A directive to this sub-plan should be included in every top-level plan to manage the resources consumed by the automated maintenance tasks.   YES
3 12872 ORA$AUTOTASK_HIGH_SUB_PLAN 4 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT YES Default sub-plan for high-priority, automated maintenance tasks. This sub-plan is referenced by ORA$AUTOTASK_SUB_PLAN and should not be referenced directly.   YES
4 12873 DEFAULT_MAINTENANCE_PLAN 4 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Default plan for maintenance windows that prioritizes SYS_GROUP operations and allocates the remaining 5% to diagnostic operations and 25% to automated maintenance operations.   YES
5 12874 DEFAULT_PLAN 4 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Default, basic, pre-defined plan that prioritizes SYS_GROUP operations and allocates minimal resources for automated maintenance and diagnostics operations.   YES
6 12875 INTERNAL_QUIESCE 2 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Plan for quiescing the database. This plan cannot be activated directly. To activate, use the quiesce command.   YES
7 12876 INTERNAL_PLAN 1 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Internally-used plan for disabling the resource manager.   YES
8 12877 APPQOS_PLAN 8 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Plan for Application QOS Management that provides a fixed set of allocations to the consumer groups that Application QOS uses to manage workload resource allocation.   YES
9 12878 DSS_PLAN 8 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Example plan for DSS workloads that prioritizes DSS queries over ETL.   NO
10 12879 ETL_CRITICAL_PLAN 8 EMPHASIS EMPHASIS ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE FIFO_TIMEOUT NO Example plan for DSS workloads that prioritizes ETL and critical DSS queries.   NO

Resource Consumer Groups

Collected from DBA_RSRC_CONSUMER_GROUPS.

# CONSUMER_GROUP_ID CONSUMER_GROUP CPU_METHOD MGMT_METHOD INT COMMENTS CATEGORY STATUS MAN
1 12880 ORA$AUTOTASK_URGENT_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for urgent maintenance tasks MAINTENANCE   YES
2 12881 BATCH_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for batch operations BATCH   NO
3 12882 ORA$DIAGNOSTICS ROUND-ROBIN ROUND-ROBIN YES Consumer group for diagnostics MAINTENANCE   YES
4 12883 ORA$AUTOTASK_HEALTH_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for health checks MAINTENANCE   YES
5 12884 ORA$AUTOTASK_SQL_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for SQL tuning MAINTENANCE   YES
6 12885 ORA$AUTOTASK_SPACE_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for space management advisors MAINTENANCE   YES
7 12886 ORA$AUTOTASK_STATS_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for gathering optimizer statistics MAINTENANCE   YES
8 12887 ORA$AUTOTASK_MEDIUM_GROUP ROUND-ROBIN ROUND-ROBIN YES Consumer group for medium-priority maintenance tasks MAINTENANCE   YES
9 12888 INTERACTIVE_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for interactive, OLTP operations INTERACTIVE   NO
10 12889 OTHER_GROUPS ROUND-ROBIN ROUND-ROBIN NO Consumer group for users not included in any consumer group with a directive in the currently active plan OTHER   YES
11 12890 DEFAULT_CONSUMER_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for users not assigned to any consumer group OTHER   YES
12 12891 SYS_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for system administrators ADMINISTRATIVE   YES
13 12892 LOW_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for low-priority sessions OTHER   NO
14 12893 ORA$APPQOS_0 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
15 12894 ORA$APPQOS_1 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
16 12895 ORA$APPQOS_2 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
17 12896 ORA$APPQOS_3 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
18 12897 ORA$APPQOS_4 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
19 12898 ORA$APPQOS_5 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
20 12899 ORA$APPQOS_6 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
21 12900 ORA$APPQOS_7 ROUND-ROBIN ROUND-ROBIN NO Consumer group for Application QOS INTERACTIVE   YES
22 12901 ETL_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for ETL BATCH   NO
23 12902 DSS_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for DSS queries BATCH   NO
24 12903 DSS_CRITICAL_GROUP ROUND-ROBIN ROUND-ROBIN NO Consumer group for critical DSS queries INTERACTIVE   NO
25 13041 AUTO_TASK_CONSUMER_GROUP ROUND-ROBIN ROUND-ROBIN NO System maintenance task consumer group OTHER   NO

Resource Plan Directives

Collected from DBA_RSRC_PLAN_DIRECTIVES.

# PLAN GROUP_OR_SUBPLAN TYPE CPU_P1 CPU_P2 CPU_P3 CPU_P4 CPU_P5 CPU_P6 CPU_P7 CPU_P8 MGMT_P1 MGMT_P2 MGMT_P3 MGMT_P4 MGMT_P5 MGMT_P6 MGMT_P7 MGMT_P8 ACTIVE_SESS_POOL_P1 QUEUEING_P1 PARALLEL_TARGET_PERCENTAGE PARALLEL_DEGREE_LIMIT_P1 SWITCH_GROUP SWITC SWITCH_TIME SWITCH_IO_MEGABYTES SWITCH_IO_REQS SWITC MAX_EST_EXEC_TIME UNDO_POOL MAX_IDLE_TIME MAX_IDLE_BLOCKER_TIME MAX_UTILIZATION_LIMIT PARALLEL_QUEUE_TIMEOUT SWITCH_TIME_IN_CALL COMMENTS STATUS MAN
1 APPQOS_PLAN ORA$APPQOS_0 CONSUMER_GROUP 0 57 0 0 0 0 0 0 0 57 0 0 0 0 0 0           FALSE       FALSE               Directive for first QOS group   YES
2 APPQOS_PLAN ORA$APPQOS_1 CONSUMER_GROUP 0 26 0 0 0 0 0 0 0 26 0 0 0 0 0 0           FALSE       FALSE               Directive for second QOS group   YES
3 APPQOS_PLAN ORA$APPQOS_2 CONSUMER_GROUP 0 12 0 0 0 0 0 0 0 12 0 0 0 0 0 0           FALSE       FALSE               Directive for third QOS group   YES
4 APPQOS_PLAN ORA$APPQOS_3 CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for fourth QOS group   YES
5 APPQOS_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 0 15 0 0 0 0 0 0 0 15 0 0 0 0 0           FALSE       FALSE               Directive for automated maintenance tasks   YES
6 APPQOS_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0           FALSE       FALSE               Directive for automated diagnostic tasks   YES
7 APPQOS_PLAN OTHER_GROUPS CONSUMER_GROUP 0 0 80 0 0 0 0 0 0 0 80 0 0 0 0 0           FALSE       FALSE               Directive for all other operations   YES
8 APPQOS_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for SYS_GROUP   YES
9 DEFAULT_MAINTENANCE_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 25 0 0 0 0 0 0 0 25 0 0 0 0 0 0           FALSE       FALSE         90     Directive for automated maintenance tasks   NO
10 DEFAULT_MAINTENANCE_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE         90     Directive for automated diagnostic tasks   NO
11 DEFAULT_MAINTENANCE_PLAN OTHER_GROUPS CONSUMER_GROUP 0 70 0 0 0 0 0 0 0 70 0 0 0 0 0 0           FALSE       FALSE               Directive for all other operations   NO
12 DEFAULT_MAINTENANCE_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for system operations   NO
13 DEFAULT_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE         90     Directive for automated maintenance tasks   NO
14 DEFAULT_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE         90     Directive for automated diagnostic tasks   NO
15 DEFAULT_PLAN OTHER_GROUPS CONSUMER_GROUP 0 90 0 0 0 0 0 0 0 90 0 0 0 0 0 0           FALSE       FALSE               Directive for all other operations   NO
16 DEFAULT_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for system operations   NO
17 DSS_PLAN BATCH_GROUP CONSUMER_GROUP 0 0 0 45 0 0 0 0 0 0 0 45 0 0 0 0           FALSE       FALSE               Directive for BATCH_GROUP   NO
18 DSS_PLAN DSS_CRITICAL_GROUP CONSUMER_GROUP 0 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0           FALSE       FALSE               Directive for DSS_CRITICAL_GROUP   NO
19 DSS_PLAN DSS_GROUP CONSUMER_GROUP 0 0 75 0 0 0 0 0 0 0 75 0 0 0 0 0           FALSE       FALSE               Directive for DSS_GROUP   NO
20 DSS_PLAN ETL_GROUP CONSUMER_GROUP 0 0 0 45 0 0 0 0 0 0 0 45 0 0 0 0           FALSE       FALSE               Directive for ETL_GROUP   NO
21 DSS_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for Oracle automated tasks   NO
22 DSS_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for Oracle diagnostics   NO
23 DSS_PLAN OTHER_GROUPS CONSUMER_GROUP 0 0 0 10 0 0 0 0 0 0 0 10 0 0 0 0           FALSE       FALSE               Directive for unclassified activity   NO
24 DSS_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for SYS_GROUP   NO
25 ETL_CRITICAL_PLAN BATCH_GROUP CONSUMER_GROUP 0 10 0 0 0 0 0 0 0 10 0 0 0 0 0 0           FALSE       FALSE               Directive for BATCH_GROUP   NO
26 ETL_CRITICAL_PLAN DSS_CRITICAL_GROUP CONSUMER_GROUP 0 35 0 0 0 0 0 0 0 35 0 0 0 0 0 0           FALSE       FALSE               Directive for DSS_CRITICAL_GROUP   NO
27 ETL_CRITICAL_PLAN DSS_GROUP CONSUMER_GROUP 0 10 0 0 0 0 0 0 0 10 0 0 0 0 0 0           FALSE       FALSE               Directive for DSS_GROUP   NO
28 ETL_CRITICAL_PLAN ETL_GROUP CONSUMER_GROUP 0 35 0 0 0 0 0 0 0 35 0 0 0 0 0 0           FALSE       FALSE               Directive for ETL_GROUP   NO
29 ETL_CRITICAL_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 0           FALSE       FALSE               Directive for Oracle automated tasks   NO
30 ETL_CRITICAL_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 0           FALSE       FALSE               Directive for Oracle diagnostics   NO
31 ETL_CRITICAL_PLAN OTHER_GROUPS CONSUMER_GROUP 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 0           FALSE       FALSE               Directive for unclassified activity   NO
32 ETL_CRITICAL_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for SYS_GROUP   NO
33 INTERNAL_PLAN OTHER_GROUPS CONSUMER_GROUP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0           FALSE       FALSE               Directive for all other operations   YES
34 INTERNAL_QUIESCE OTHER_GROUPS CONSUMER_GROUP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0         FALSE       FALSE               Directive for all other operations   YES
35 INTERNAL_QUIESCE SYS_GROUP CONSUMER_GROUP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0           FALSE       FALSE               Directive for system operations   YES
36 MIXED_WORKLOAD_PLAN BATCH_GROUP CONSUMER_GROUP 0 0 100 0 0 0 0 0 0 0 100 0 0 0 0 0           FALSE       FALSE               Directive for batch operations   NO
37 MIXED_WORKLOAD_PLAN INTERACTIVE_GROUP CONSUMER_GROUP 0 85 0 0 0 0 0 0 0 85 0 0 0 0 0 0       1 BATCH_GROUP TRUE 60     FALSE             60 Directive for interactive operations   NO
38 MIXED_WORKLOAD_PLAN ORA$AUTOTASK_SUB_PLAN PLAN 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for automated maintenance tasks   NO
39 MIXED_WORKLOAD_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for automated diagnostic tasks   NO
40 MIXED_WORKLOAD_PLAN OTHER_GROUPS CONSUMER_GROUP 0 5 0 0 0 0 0 0 0 5 0 0 0 0 0 0           FALSE       FALSE               Directive for all other operations   NO
41 MIXED_WORKLOAD_PLAN SYS_GROUP CONSUMER_GROUP 75 0 0 0 0 0 0 0 75 0 0 0 0 0 0 0           FALSE       FALSE               Directive for system operations   NO
42 ORA$AUTOTASK_HIGH_SUB_PLAN ORA$AUTOTASK_HEALTH_GROUP CONSUMER_GROUP 25 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0           FALSE       FALSE               Directive for health check tasks   NO
43 ORA$AUTOTASK_HIGH_SUB_PLAN ORA$AUTOTASK_SPACE_GROUP CONSUMER_GROUP 25 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0           FALSE       FALSE               Directive for space management advisory tasks   NO
44 ORA$AUTOTASK_HIGH_SUB_PLAN ORA$AUTOTASK_SQL_GROUP CONSUMER_GROUP 25 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0           FALSE       FALSE               Directive for SQL tuning tasks   NO
45 ORA$AUTOTASK_HIGH_SUB_PLAN ORA$AUTOTASK_STATS_GROUP CONSUMER_GROUP 25 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0           FALSE       FALSE               Directive for gathering optimizer statistics tasks   NO
46 ORA$AUTOTASK_SUB_PLAN ORA$AUTOTASK_HIGH_SUB_PLAN PLAN 0 100 0 0 0 0 0 0 0 100 0 0 0 0 0 0           FALSE       FALSE               Directive for high-priority automated tasks   NO
47 ORA$AUTOTASK_SUB_PLAN ORA$AUTOTASK_MEDIUM_GROUP CONSUMER_GROUP 0 0 100 0 0 0 0 0 0 0 100 0 0 0 0 0           FALSE       FALSE               Directive for medium-priority automated tasks   NO
48 ORA$AUTOTASK_SUB_PLAN ORA$AUTOTASK_URGENT_GROUP CONSUMER_GROUP 100 0 0 0 0 0 0 0 100 0 0 0 0 0 0 0           FALSE       FALSE               Directive for urgent automated tasks   NO

Resource Consumer Group Privileges

Collected from DBA_RSRC_CONSUMER_GROUP_PRIVS.

# GRANTEE GRANTED_GROUP GRA INI
1 PUBLIC DEFAULT_CONSUMER_GROUP YES YES
2 PUBLIC LOW_GROUP NO NO
3 SYSTEM SYS_GROUP NO YES

Resource Group Mappings

Collected from DBA_RSRC_GROUP_MAPPINGS.

# ATTRIBUTE VALUE CONSUMER_GROUP STATUS
1 ORACLE_FUNCTION BACKUP BATCH_GROUP  
2 ORACLE_FUNCTION COPY BATCH_GROUP  
3 ORACLE_FUNCTION DATALOAD ETL_GROUP  
4 ORACLE_USER SYS SYS_GROUP  
5 ORACLE_USER SYSTEM SYS_GROUP  

Resource Mapping Priority

Collected from DBA_RSRC_MAPPING_PRIORITY.

# ATTRIBUTE PRIORITY STATUS
1 CLIENT_ID 11  
2 CLIENT_MACHINE 10  
3 CLIENT_OS_USER 9  
4 CLIENT_PROGRAM 8  
5 EXPLICIT 1  
6 MODULE_NAME 5  
7 MODULE_NAME_ACTION 4  
8 ORACLE_USER 7  
9 SERVICE_MODULE 3  
10 SERVICE_MODULE_ACTION 2  
11 SERVICE_NAME 6  

1460440.1 PXHCDR 11.4.5.8 2018-01-25/16:43:46