[Home] [Help] [Dependency Information]

TABLE: SYS.WI$_STATEMENT

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WI$_STATEMENT_PK

1. JOBID
2. TEMPLATEID
3. RANK

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000626798C00003$$	LOB	UNIQUE	SYSAUX
WI$_STATEMENT_PK	NORMAL	UNIQUE	SYSAUX	JOBID TEMPLATEID RANK

Foreign Keys

Table		Foreign Table	Foreign Key Column
WI$_STATEMENT		WI$_TEMPLATE	WI$_STATEMENT JOBID WI$_STATEMENT TEMPLATEID

Columns

Query Text

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

SELECT JOBID
,      TEMPLATEID
,      SQLTEXT
,      RANK
FROM SYS.WI$_STATEMENT;

Dependencies

[top of page]

SYS.WI$_STATEMENT does not reference any database object

SYS.WI$_STATEMENT is referenced by following:

SYS

DBA_WI_STATEMENTS