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
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | GRANTEE | GRANTED_GROUP | GRA | INI |
---|---|---|---|---|
1 | PUBLIC | DEFAULT_CONSUMER_GROUP | YES | YES |
2 | PUBLIC | LOW_GROUP | NO | NO |
3 | SYSTEM | SYS_GROUP | NO | YES |
# | 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 |
# | 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 |