[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_TASKS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
TASK_ID | NUMBER | Yes | ||
TASK_NAME | VARCHAR2 | (128) | ||
DESCRIPTION | VARCHAR2 | (256) | ||
ADVISOR_NAME | VARCHAR2 | (128) | ||
CREATED | DATE | Yes | ||
LAST_MODIFIED | DATE | Yes | ||
PARENT_TASK_ID | NUMBER | |||
PARENT_RXEC_ID | NUMBER | |||
LAST_EXECUTION | VARCHAR2 | (128) | ||
EXECUTION_TYPE | VARCHAR2 | (30) | ||
EXECUTION_TYPE# | NUMBER | |||
EXECUTION_DESCRIPTION | VARCHAR2 | (256) | ||
EXECUTION_START | DATE | |||
EXECUTION_END | DATE | |||
STATUS | VARCHAR2 | (11) | ||
STATUS_MESSAGE | VARCHAR2 | (4000) | ||
PCT_COMPLETION_TIME | NUMBER | |||
PROGRESS_METRIC | NUMBER | |||
METRIC_UNITS | VARCHAR2 | (64) | ||
ACTIVITY_COUNTER | NUMBER | |||
RECOMMENDATION_COUNT | NUMBER | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
SOURCE | VARCHAR2 | (128) | ||
HOW_CREATED | VARCHAR2 | (30) | ||
READ_ONLY | VARCHAR2 | (5) | ||
SYSTEM_TASK | VARCHAR2 | (5) | ||
ADVISOR_ID | NUMBER | Yes | ||
STATUS# | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TASK_ID
, TASK_NAME
, DESCRIPTION
, ADVISOR_NAME
, CREATED
, LAST_MODIFIED
, PARENT_TASK_ID
, PARENT_RXEC_ID
, LAST_EXECUTION
, EXECUTION_TYPE
, EXECUTION_TYPE#
, EXECUTION_DESCRIPTION
, EXECUTION_START
, EXECUTION_END
, STATUS
, STATUS_MESSAGE
, PCT_COMPLETION_TIME
, PROGRESS_METRIC
, METRIC_UNITS
, ACTIVITY_COUNTER
, RECOMMENDATION_COUNT
, ERROR_MESSAGE
, SOURCE
, HOW_CREATED
, READ_ONLY
, SYSTEM_TASK
, ADVISOR_ID
, STATUS#
FROM SYS.DBA_ADVISOR_TASKS;
|
|
|