[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ADV_EXECUTIONS

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ADV_EXECS_PK

1. TASK_ID
2. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ADV_EXECS_IDX_01	NORMAL	UNIQUE	SYSAUX	ID
WRI$_ADV_EXECS_PK	NORMAL	UNIQUE	SYSAUX	TASK_ID NAME
WRI$_ADV_EXECS_IDX_02	NORMAL	NONUNIQUE	SYSAUX	ADVISOR_ID EXEC_START
WRI$_ADV_EXECS_IDX_03	NORMAL	NONUNIQUE	SYSAUX	TASK_ID EXEC_START

Columns

Query Text

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

SELECT ID
,      TASK_ID
,      NAME
,      DESCRIPTION
,      EXEC_TYPE
,      EXEC_TYPE_ID
,      ADVISOR_ID
,      EXEC_START
,      EXEC_MTIME
,      EXEC_END
,      STATUS
,      STATUS_MSG_ID
,      ERROR_MSG_ID
,      FLAGS
FROM SYS.WRI$_ADV_EXECUTIONS;

Dependencies

[top of page]

SYS.WRI$_ADV_EXECUTIONS does not reference any database object

SYS.WRI$_ADV_EXECUTIONS is referenced by following:

SYS

DBA_ADVISOR_EXECUTIONS

DBA_ADVISOR_EXEC_PARAMETERS

DBA_ADVISOR_LOG

DBA_ADVISOR_SQLSTATS

DBA_ADVISOR_TASKS

DBMS_SQLTUNE_INTERNAL - show dependent code

DBMS_SQLTUNE_UTIL2 - show dependent code

PRVT_ADVISOR - show dependent code

USER_ADVISOR_EXECUTIONS

USER_ADVISOR_EXEC_PARAMETERS

USER_ADVISOR_LOG

USER_ADVISOR_SQLSTATS

USER_ADVISOR_TASKS