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

VIEW: SYS.DBA_ADVISOR_EXECUTIONS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
TASK_ID NUMBER
Yes
TASK_NAME VARCHAR2 (128)
EXECUTION_NAME VARCHAR2 (128) Yes
EXECUTION_ID NUMBER
Yes
DESCRIPTION VARCHAR2 (256)
EXECUTION_TYPE VARCHAR2 (30)
EXECUTION_TYPE# NUMBER

EXECUTION_START DATE

EXECUTION_LAST_MODIFIED DATE
Yes
EXECUTION_END DATE

ADVISOR_NAME VARCHAR2 (128)
ADVISOR_ID NUMBER
Yes
STATUS VARCHAR2 (11)
STATUS# NUMBER
Yes
STATUS_MESSAGE VARCHAR2 (4000)
ERROR_MESSAGE VARCHAR2 (4000)
Query Text

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


SELECT OWNER
,      TASK_ID
,      TASK_NAME
,      EXECUTION_NAME
,      EXECUTION_ID
,      DESCRIPTION
,      EXECUTION_TYPE
,      EXECUTION_TYPE#
,      EXECUTION_START
,      EXECUTION_LAST_MODIFIED
,      EXECUTION_END
,      ADVISOR_NAME
,      ADVISOR_ID
,      STATUS
,      STATUS#
,      STATUS_MESSAGE
,      ERROR_MESSAGE
FROM SYS.DBA_ADVISOR_EXECUTIONS;

Dependencies

[top of page]

SYS.DBA_ADVISOR_EXECUTIONS references the following:

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

SchemaPUBLIC
SynonymDBA_ADVISOR_EXECUTIONS
SchemaSYS
ProcedureDBMS_FEATURE_AUTOSTA - show dependent code
ProcedureDBMS_FEATURE_SEGADV_USER - show dependent code
Package BodyDBMS_MANAGEMENT_PACKS - show dependent code
Package BodyDBMS_SPM_INTERNAL - show dependent code
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code
Package BodyDBMS_SQLTUNE_UTIL1 - show dependent code
Package BodyPRVT_ADVISOR - show dependent code
Package BodyPRVT_SQLPA - show dependent code
TYPE BODYWRI$_ADV_HDM_T
TYPE BODYWRI$_ADV_SQLTUNE
TYPE BODYWRI$_REPT_SQLT