4.24 DBA_ADVISOR_LOG
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 of the task |
|
|
|
Identifier of the task |
|
|
|
Name of the task |
|
|
|
Execution start date and time of the task |
|
|
|
Execution end date and time of the task |
|
|
|
Current operational status of the task:
|
|
|
|
Informational message provided by the advisor regarding the status |
|
|
|
Percent completion, in terms of time, of the task when it is executing |
|
|
|
Metric that measures the progress of the task in terms of quality. Each advisor could have its own metric. |
|
|
|
Unit of the metric used to measure progress |
|
|
|
Counter that is updated frequently by the advisor, denoting that useful work is being performed |
|
|
|
Number of recommendations produced |
|
|
|
Informational message or an error message indicating the current operation or condition |
See Also: