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

E40402-10
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

V$ADVISOR_PROGRESS

V$ADVISOR_PROGRESS displays information about the progress of advisor execution.

Column Datatype Description
SID NUMBER Session ID
SERIAL# NUMBER Session serial number
USERNAME VARCHAR2(30) Oracle user name
OPNAME VARCHAR2(64) Operation name
ADVISOR_NAME VARCHAR2(64) Advisor name
TASK_ID NUMBER Task ID
TARGET_DESC VARCHAR2(32) Description of the target of the advisor
SOFAR NUMBER Amount of work done so far
TOTALWORK NUMBER Total work to be done
UNITS VARCHAR2(32) Units that the work is measured in
BENEFIT_SOFAR NUMBER Benefit obtained so far
BENEFIT_MAX NUMBER Estimate of maximum benefit that could be obtained
FINDINGS NUMBER Number of findings so far
RECOMMENDATIONS NUMBER Number of recommendations so far
TIME_REMAINING NUMBER Estimate of time remaining for the completion of the task (in seconds)
START_TIME DATE Start time of the task
LAST_UPDATE_TIME DATE Last time progress was posted
ELAPSED_SECONDS NUMBER Elapsed time so far
ADVISOR_METRIC1 NUMBER Value of the advisor-specific metric
METRIC1_DESC VARCHAR2(64) Description of the advisor-specific metric
EXECUTION_TYPE VARCHAR2(64) Type of the last execution. This information is optional for single-execution tasks.