[Home] [Help] [Dependency Information]
Object Name: | V_$ADVISOR_PROGRESS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SID | NUMBER | |||
SERIAL# | NUMBER | |||
USERNAME | VARCHAR2 | (30) | ||
OPNAME | VARCHAR2 | (64) | ||
ADVISOR_NAME | VARCHAR2 | (64) | ||
TASK_ID | NUMBER | |||
TARGET_DESC | VARCHAR2 | (32) | ||
SOFAR | NUMBER | |||
TOTALWORK | NUMBER | |||
UNITS | VARCHAR2 | (32) | ||
BENEFIT_SOFAR | NUMBER | |||
BENEFIT_MAX | NUMBER | |||
FINDINGS | NUMBER | |||
RECOMMENDATIONS | NUMBER | |||
TIME_REMAINING | NUMBER | |||
START_TIME | DATE | |||
LAST_UPDATE_TIME | DATE | |||
ELAPSED_SECONDS | NUMBER | |||
ADVISOR_METRIC1 | NUMBER | |||
METRIC1_DESC | VARCHAR2 | (64) | ||
EXECUTION_TYPE | VARCHAR2 | (64) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SID
, SERIAL#
, USERNAME
, OPNAME
, ADVISOR_NAME
, TASK_ID
, TARGET_DESC
, SOFAR
, TOTALWORK
, UNITS
, BENEFIT_SOFAR
, BENEFIT_MAX
, FINDINGS
, RECOMMENDATIONS
, TIME_REMAINING
, START_TIME
, LAST_UPDATE_TIME
, ELAPSED_SECONDS
, ADVISOR_METRIC1
, METRIC1_DESC
, EXECUTION_TYPE
, CON_ID
FROM SYS.V_$ADVISOR_PROGRESS;
|
|
|