[Home] [Help]
[Dependency Information]
TABLE: SYS.WRI$_ADV_TASKS
Object Details
Object Name: | WRI$_ADV_TASKS |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: WRI$_ADV_TASKS_PK
- ID
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
WRI$_ADV_TASKS_IDX_01
|
NORMAL
|
UNIQUE
|
SYSAUX
|
NAME
OWNER#
|
WRI$_ADV_TASKS_IDX_02
|
NORMAL
|
UNIQUE
|
SYSAUX
|
OWNER#
ID
|
WRI$_ADV_TASKS_PK
|
NORMAL
|
UNIQUE
|
SYSAUX
|
ID
|
WRI$_ADV_TASKS_IDX_03
|
NORMAL
|
NONUNIQUE
|
SYSAUX
|
ADVISOR_ID
EXEC_START
|
WRI$_ADV_TASKS_IDX_04
|
NORMAL
|
NONUNIQUE
|
SYSAUX
|
PARENT_ID
PARENT_REC_ID
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
NUMBER |
|
Yes |
|
OWNER# |
NUMBER |
|
Yes |
|
OWNER_NAME |
VARCHAR2 |
(128) |
|
|
NAME |
VARCHAR2 |
(128) |
|
|
DESCRIPTION |
VARCHAR2 |
(256) |
|
|
ADVISOR_ID |
NUMBER |
|
Yes |
|
ADVISOR_NAME |
VARCHAR2 |
(128) |
|
|
CTIME |
DATE |
|
Yes |
|
MTIME |
DATE |
|
Yes |
|
PARENT_ID |
NUMBER |
|
|
|
PARENT_REC_ID |
NUMBER |
|
|
|
PROPERTY |
NUMBER |
|
Yes |
|
VERSION |
NUMBER |
|
|
|
EXEC_START |
DATE |
|
|
|
EXEC_END |
DATE |
|
|
|
STATUS |
NUMBER |
|
Yes |
|
STATUS_MSG_ID |
NUMBER |
|
|
|
PCT_COMPLETION_TIME |
NUMBER |
|
|
|
PROGRESS_METRIC |
NUMBER |
|
|
|
METRIC_UNITS |
VARCHAR2 |
(64) |
|
|
ACTIVITY_COUNTER |
NUMBER |
|
|
|
REC_COUNT |
NUMBER |
|
|
|
ERROR_MSG# |
NUMBER |
|
|
|
CLEANUP |
NUMBER |
|
|
|
HOW_CREATED |
VARCHAR2 |
(30) |
|
|
SOURCE |
VARCHAR2 |
(128) |
|
|
LAST_EXEC_NAME |
VARCHAR2 |
(128) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OWNER#
, OWNER_NAME
, NAME
, DESCRIPTION
, ADVISOR_ID
, ADVISOR_NAME
, CTIME
, MTIME
, PARENT_ID
, PARENT_REC_ID
, PROPERTY
, VERSION
, EXEC_START
, EXEC_END
, STATUS
, STATUS_MSG_ID
, PCT_COMPLETION_TIME
, PROGRESS_METRIC
, METRIC_UNITS
, ACTIVITY_COUNTER
, REC_COUNT
, ERROR_MSG#
, CLEANUP
, HOW_CREATED
, SOURCE
, LAST_EXEC_NAME
FROM SYS.WRI$_ADV_TASKS;
Dependencies
[top of page]
SYS.WRI$_ADV_TASKS does not reference any database object
SYS.WRI$_ADV_TASKS is referenced by following:
-
SYS
-
DBA_ADVISOR_ACTIONS
-
DBA_ADVISOR_DIRECTIVES
-
DBA_ADVISOR_DIR_TASK_INST
-
DBA_ADVISOR_EXECUTIONS
-
DBA_ADVISOR_EXEC_PARAMETERS
-
DBA_ADVISOR_FINDINGS
-
DBA_ADVISOR_JOURNAL
-
DBA_ADVISOR_LOG
-
DBA_ADVISOR_OBJECTS
-
DBA_ADVISOR_PARAMETERS
-
DBA_ADVISOR_RATIONALE
-
DBA_ADVISOR_RECOMMENDATIONS
-
DBA_ADVISOR_SQLA_COLVOL
-
DBA_ADVISOR_SQLA_REC_SUM
-
DBA_ADVISOR_SQLA_TABLES
-
DBA_ADVISOR_SQLA_TABVOL
-
DBA_ADVISOR_SQLA_WK_MAP
-
DBA_ADVISOR_SQLA_WK_STMTS
-
DBA_ADVISOR_SQLA_WK_SUM
-
DBA_ADVISOR_SQLPLANS
-
DBA_ADVISOR_SQLSTATS
-
DBA_ADVISOR_SQLW_COLVOL
-
DBA_ADVISOR_SQLW_JOURNAL
-
DBA_ADVISOR_SQLW_PARAMETERS
-
DBA_ADVISOR_SQLW_STMTS
-
DBA_ADVISOR_SQLW_SUM
-
DBA_ADVISOR_SQLW_TABLES
-
DBA_ADVISOR_SQLW_TABVOL
-
DBA_ADVISOR_SQLW_TEMPLATES
-
DBA_ADVISOR_TASKS
-
DBA_ADVISOR_TEMPLATES
-
DBA_TUNE_MVIEW
-
DBMS_SQLTUNE_INTERNAL
- show dependent code
-
DBMS_SQLTUNE_UTIL2
- show dependent code
-
PRVT_ACCESS_ADVISOR
- show dependent code
-
PRVT_ADVISOR
- show dependent code
-
PRVT_HDM
- show dependent code
-
PRVT_SYS_TUNE_MVIEW
- show dependent code
-
PRVT_WORKLOAD
- show dependent code
-
USER_ADDM_INSTANCES
-
USER_ADVISOR_ACTIONS
-
USER_ADVISOR_DIRECTIVES
-
USER_ADVISOR_DIR_TASK_INST
-
USER_ADVISOR_EXECUTIONS
-
USER_ADVISOR_EXEC_PARAMETERS
-
USER_ADVISOR_FINDINGS
-
USER_ADVISOR_JOURNAL
-
USER_ADVISOR_LOG
-
USER_ADVISOR_OBJECTS
-
USER_ADVISOR_PARAMETERS
-
USER_ADVISOR_RATIONALE
-
USER_ADVISOR_RECOMMENDATIONS
-
USER_ADVISOR_SQLA_COLVOL
-
USER_ADVISOR_SQLA_REC_SUM
-
USER_ADVISOR_SQLA_TABLES
-
USER_ADVISOR_SQLA_TABVOL
-
USER_ADVISOR_SQLA_WK_MAP
-
USER_ADVISOR_SQLA_WK_STMTS
-
USER_ADVISOR_SQLA_WK_SUM
-
USER_ADVISOR_SQLPLANS
-
USER_ADVISOR_SQLSTATS
-
USER_ADVISOR_SQLW_COLVOL
-
USER_ADVISOR_SQLW_JOURNAL
-
USER_ADVISOR_SQLW_PARAMETERS
-
USER_ADVISOR_SQLW_STMTS
-
USER_ADVISOR_SQLW_SUM
-
USER_ADVISOR_SQLW_TABLES
-
USER_ADVISOR_SQLW_TABVOL
-
USER_ADVISOR_SQLW_TEMPLATES
-
USER_ADVISOR_TASKS
-
USER_ADVISOR_TEMPLATES
-
USER_SQLTUNE_BINDS
-
USER_SQLTUNE_PLANS
-
USER_SQLTUNE_RATIONALE_PLAN
-
USER_SQLTUNE_STATISTICS
-
USER_TUNE_MVIEW
-
WRI$_ADV_HDM_T
-
_DBA_STREAMS_ACTIONS
-
_DBA_STREAMS_FINDINGS
-
_DBA_STREAMS_RECOMMENDATIONS