4.9 DBA_ADDM_TASKS

DBA_ADDM_TASKS displays information about all ADDM tasks in the database.

The view contains one row for each row in the related DBA_ADVISOR_TASKS view that has ADVISOR_NAME=ADDM and STATUS=COMPLETED.

Related View

USER_ADDM_TASKS displays information about the ADDM tasks owned by the current user. The view contains one row for each row in the related USER_ADVISOR_TASKS view that has ADVISOR_NAME=ADDM and STATUS=COMPLETED. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the task

TASK_ID

NUMBER

NOT NULL

Unique identifier of the task

TASK_NAME

VARCHAR2(128)

Name of the task

DESCRIPTION

VARCHAR2(256)

User-supplied description of the task

ADVISOR_NAME

VARCHAR2(128)

Advisor associated with the task

CREATED

DATE

NOT NULL

Creation date of the task

LAST_MODIFIED

DATE

NOT NULL

Date on which the task was last modified

PARENT_TASK_ID

NUMBER

Identifier of the parent task (if the task was created because of the recommendation of another task)

PARENT_RXEC_ID

NUMBER

Identifier of the recommendation within the parent task that resulted in the creation of the task

LAST_EXECUTION

VARCHAR2(128)

Name of the current or last task execution

EXECUTION_TYPE

VARCHAR2(128)

Type of the last execution. This information is optional for single-execution tasks.

EXECUTION_TYPE#

NUMBER

Reserved for internal use

EXECUTION_DESCRIPTION

VARCHAR2(256)

Optional description of the last execution

EXECUTION_START

DATE

Execution start date and time of the task

EXECUTION_END

DATE

Execution end date and time of the task

STATUS

VARCHAR2(11)

Current operational status of the task:

  • INITIAL - Initial state of the task; no recommendations are present

  • EXECUTING - Task is currently running

  • INTERRUPTED - Task analysis was interrupted by the user. Recommendation data, if present, can be viewed and reported at this time.

  • COMPLETED - Task successfully completed the analysis operation. Recommendation data can be viewed and reported.

  • ERROR - An error occurred during the analysis operation. Recommendations, if present, can be viewed and reported at this time.

STATUS_MESSAGE

VARCHAR2(4000)

Informational message provided by the advisor, regarding the status

PCT_COMPLETION_TIME

NUMBER

Percent completion, in terms of time, of the task when it is executing

PROGRESS_METRIC

NUMBER

Metric that measures the progress of the task in terms of quality. Each advisor may have its own metric.

METRIC_UNITS

VARCHAR2(64)

Unit of the metric used to measure progress

ACTIVITY_COUNTER

NUMBER

Counter that is updated frequently by the advisor, denoting that useful work is being performed

RECOMMENDATION_COUNT

NUMBER

Number of recommendations produced

ERROR_MESSAGE

VARCHAR2(4000)

Informational message or an error message indicating the current operation or condition

SOURCE

VARCHAR2(128)

Optional name that identifies the creator of the task

HOW_CREATED

VARCHAR2(30)

Optional task or template on which the object was based

READ_ONLY

VARCHAR2(5)

Indicates whether the task is read-only (TRUE) or not (FALSE)

SYSTEM_TASK

VARCHAR2(5)

Indicates whether the task is a system task (TRUE) or not (FALSE). The automatic SQL tuning task, SYS_AUTO_SQL_TUNING_TASK, is one example of a system task.

ADVISOR_ID

NUMBER

NOT NULL

Unique identifier for the advisor

STATUS#

NUMBER

Reserved for internal use

DBID

NUMBER

The database ID that the task was using

DBNAME

VARCHAR2(9)

The name of the database that the task was analyzing

DBVERSION

VARCHAR2(17)

The version of the database that the task was analyzing

ANALYSIS_VERSION

VARCHAR2(17)

The version of the database that executed the task

BEGIN_SNAP_ID

NUMBER

The snapshot ID that starts the analysis period

BEGIN_TIME

TIMESTAMP(3)

The SYSDATE at the time the BEGIN_SNAP_ID was taken

END_SNAP_ID

NUMBER

The snapshot ID that ends the analysis period

END_TIME

TIMESTAMP(3)

The SYSDATE at the time the END_SNAP_ID was taken

REQUESTED_ANALYSIS

VARCHAR2(8)

The type of ADDM analysis that was requested before task execution, as follows:

DATABASE - global ADDM

INSTANCE - local ADDM

PARTIAL - continental ADDM

ACTUAL_ANALYSIS

VARCHAR2(8)

The type of ADDM analysis that was actually performed when the task was executed (either DATABASE, INSTANCE, or PARTIAL)

DATABASE_TIME

NUMBER

The total database time accumulated in the analysis period (and analyzed instances) in microseconds

ACTIVE_SESSIONS

NUMBER

The average active sessions during the analysis period (and analyzed sessions)

METER_LEVEL

VARCHAR2(6)

Reserved for future use

FDG_COUNT

NUMBER

The number of findings for the ADDM task, which will appear in the list of findings in a default ADDM report

DB_TYPE_DETECTEDFoot 1

VARCHAR2(10)

Indicates the open mode of the database that the task was analyzing, as detected by ADDM. Possible values:

  • READ-ONLY

  • READ-WRITE

DB_TYPE_ANALYZEDFootref 1

VARCHAR2(10)

Indicates the assumed open mode of the database that the task was analyzing. If the value of this column is different from the value of the DB_TYPE_DETECTED column, then ADDM ignored the detected open mode of the database and analyzed the task as if it occurred on a database with the assumed open mode. Possible values:

  • READ-ONLY

  • READ-WRITE

CDB_TYPE_DETECTEDFootref 1

VARCHAR2(25)

Indicates the type of database that the task was analyzing, as detected by ADDM. Possible values:

  • NON-CDB - A non-CDB

  • CDB ROOT - The root container in a CDB

  • PDB - A pluggable database (PDB) in a CDB

  • AUTONOMOUS DATA WAREHOUSE - A PDB that hosts an Oracle Autonomous Data Warehouse Cloud service

  • AUTONOMOUS OLTP - A PDB that hosts an Oracle Autonomous Transaction Processing service

CDB_TYPE_ANALYZEDFootref 1

VARCHAR2(25)

Indicates the assumed type of database that the task was analyzing. If the value of this column is different from the value of the CDB_TYPE_DETECTED column, then ADDM ignored the detected type of database and analyzed the task as if it occurred on the assumed type of database. Possible values:

  • NON-CDB - A non-CDB

  • CDB ROOT - The root container in a CDB

  • PDB - A pluggable database (PDB) in a CDB

  • AUTONOMOUS DATA WAREHOUSE - A PDB that hosts an Oracle Autonomous Data Warehouse Cloud service

  • AUTONOMOUS OLTP - A PDB that hosts an Oracle Autonomous Transaction Processing service

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1. If the task was analyzing a database at a release earlier than Oracle Database 19c, and that database was subsequently upgraded to Oracle Database 19c, then the value of this column is NULL.

See Also:

"USER_ADDM_TASKS"