8.11 V$ADVISOR_PROGRESS
V$ADVISOR_PROGRESS
displays information about the progress of advisor execution.
Column | Datatype | Description |
---|---|---|
|
|
Session ID |
|
|
Session serial number |
|
|
Oracle user name |
|
|
Operation name |
|
|
Advisor name |
|
|
Task ID |
|
|
Description of the target of the advisor |
|
|
Amount of work done so far |
|
|
Total work to be done |
|
|
Units that the work is measured in |
|
|
Benefit obtained so far |
|
|
Estimate of maximum benefit that could be obtained |
|
|
Number of findings so far |
|
|
Number of recommendations so far |
|
|
Estimate of time remaining for the completion of the task (in seconds) |
|
|
Start time of the task |
|
|
Last time progress was posted |
|
|
Elapsed time so far |
|
|
Value of the advisor-specific metric |
|
|
Description of the advisor-specific metric |
|
|
Type of the last execution. This information is optional for single-execution tasks. |
|
|
The ID of the container to which the data pertains. Possible values include:
|