Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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   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(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)   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