DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_ADVISOR_TASKS

Object Details
Object Name: USER_ADVISOR_TASKS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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_REC_ID NUMBER

LAST_EXECUTION VARCHAR2 (128)
EXECUTION_TYPE VARCHAR2 (30)
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      TASK_NAME
,      DESCRIPTION
,      ADVISOR_NAME
,      CREATED
,      LAST_MODIFIED
,      PARENT_TASK_ID
,      PARENT_REC_ID
,      LAST_EXECUTION
,      EXECUTION_TYPE
,      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.USER_ADVISOR_TASKS;

Dependencies

[top of page]

SYS.USER_ADVISOR_TASKS references the following:

SchemaSYS
PL/SQL PackageDBMS_ADVISOR - show dependent code
TableWRI$_ADV_EXECUTIONS
TableWRI$_ADV_TASKS
SYS.USER_ADVISOR_TASKS is referenced by following:

SchemaPUBLIC
SynonymUSER_ADVISOR_TASKS
SchemaSYS
Package BodyDBMS_ADDM - show dependent code
Package BodyDBMS_SQLPA - show dependent code
ViewUSER_ADDM_TASKS