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

TABLE: SYS.WI$_EXECUTION_ORDER

Object Details
Object Name: WI$_EXECUTION_ORDER
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_EXECUTION_ORDER_PK
  1. ColumnJOBID
  2. ColumnFILEID
  3. ColumnRANK
Indexes
Index Type Uniqueness Tablespace Column
WI$_EXECUTION_ORDER_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
ColumnFILEID
ColumnRANK
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_EXECUTION_ORDER WI$_EXECUTION_ORDER_FK1 TableWI$_CAPTURE_FILE WI$_EXECUTION_ORDER JOBID
WI$_EXECUTION_ORDER FILEID
WI$_EXECUTION_ORDER WI$_EXECUTION_ORDER_FK2 TableWI$_TEMPLATE WI$_EXECUTION_ORDER JOBID
WI$_EXECUTION_ORDER TEMPLATEID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
FILEID NUMBER
Yes
RANK NUMBER
Yes
TEMPLATEID NUMBER
Yes
DBTIME NUMBER
Yes
Query Text

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


SELECT JOBID
,      FILEID
,      RANK
,      TEMPLATEID
,      DBTIME
FROM SYS.WI$_EXECUTION_ORDER;

Dependencies

[top of page]

SYS.WI$_EXECUTION_ORDER does not reference any database object

SYS.WI$_EXECUTION_ORDER is referenced by following:

SchemaSYS
ViewDBA_WI_TEMPLATE_EXECUTIONS