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(30)   Owner of the task
TASK_ID NUMBER NOT NULL Unique identifier of the task
TASK_NAME VARCHAR2(30)   Name of the task
DESCRIPTION VARCHAR2(256)   User-supplied description of the task
ADVISOR_NAME VARCHAR2(30)   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 as a result 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(30)   Name of the current or last task execution
EXECUTION_TYPE VARCHAR2(30)   Type of the last execution. This information is optional for single-execution tasks.
EXECUTION_TYPE# NUMBER   ???
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(30)   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)   ???
ADVISOR_ID NUMBER NOT NULL Unique identifier for the advisor
STATUS# NUMBER   ???
DBID NUMBER   The database ID that the task was using
DBNAME VARCHAR2(9)   The name of the database that the task was analyzing
DIVERSION VARCHAR2(17)   ???
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)   ???