DBA_ADVISOR_LOG

Oracle 11gR1

DBA_ADVISOR_LOG displays information about the current state of all tasks in the database, as well as execution-specific data such as progress monitoring and completion status. The view contains one row for each task.

Related View

USER_ADVISOR_LOG displays information about the current state of the tasks owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the task
TASK_ID	NUMBER	NOT NULL	Identifier of the task
TASK_NAME	VARCHAR2(30)		Name of the task
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 · COMPLETED - Task successfully completed the analysis operation. Recommendation data can be viewed and reported. · INTERRUPTED - Task analysis was interrupted by the user. Recommendation data, if present, can be viewed and reported at this time. · CANCELLED · FATAL ERROR - A fatal error occurred during the analysis operation. All recommendation data is unusable.
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 could 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

Note:

1.

SELECT * FROM DBA_ADVISOR_LOG;

OWNER	TASK_ID	TASK_NAME	EXECUTION_ START	EXECUTION_ END	STATUS	PCT_ COMPLETION_ TIME	PROGRESS_ METRIC	METRIC_ UNITS	ACTIVITY_ COUNTER	RECOMMENDATION_ COUNT
SYS	29074	ADDM:2334540272_1_19341	2008-08-28 11:00:23 AM	2008-08-28 11:00:25 AM	COMPLETED	0	0		0	0
SYS	29064	ADDM:2334540272_1_19340	2008-08-28 10:01:13 AM	2008-08-28 10:01:15 AM	COMPLETED	0	0		0	0
SYS	29054	ADDM:2334540272_1_19339	2008-08-28 9:00:49 AM	2008-08-28 9:00:51 AM	COMPLETED	0	0		0	0

Oracle data dictionary views