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

TABLE: SYS.WRI$_ADV_ACTIONS

Object Details
Object Name: WRI$_ADV_ACTIONS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRI$_ADV_ACTIONS_PK
  1. ColumnTASK_ID
  2. ColumnID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000363724C00010$$ LOB UNIQUE TablespaceSYSAUX
SYS_IL0000363724C00011$$ LOB UNIQUE TablespaceSYSAUX
WRI$_ADV_ACTIONS_PK NORMAL UNIQUE TablespaceSYSAUX ColumnTASK_ID
ColumnID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
TASK_ID NUMBER
Yes
OBJ_ID NUMBER

COMMAND NUMBER
Yes
FLAGS NUMBER

ATTR1 VARCHAR2 (4000)
ATTR2 VARCHAR2 (4000)
ATTR3 VARCHAR2 (4000)
ATTR4 VARCHAR2 (4000)
ATTR5 CLOB (4000)
ATTR6 CLOB (4000)
NUM_ATTR1 NUMBER

NUM_ATTR2 NUMBER

NUM_ATTR3 NUMBER

NUM_ATTR4 NUMBER

NUM_ATTR5 NUMBER

MSG_ID NUMBER

FILTERED CHAR (1)
EXEC_NAME VARCHAR2 (128)
Query Text

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


SELECT ID
,      TASK_ID
,      OBJ_ID
,      COMMAND
,      FLAGS
,      ATTR1
,      ATTR2
,      ATTR3
,      ATTR4
,      ATTR5
,      ATTR6
,      NUM_ATTR1
,      NUM_ATTR2
,      NUM_ATTR3
,      NUM_ATTR4
,      NUM_ATTR5
,      MSG_ID
,      FILTERED
,      EXEC_NAME
FROM SYS.WRI$_ADV_ACTIONS;

Dependencies

[top of page]

SYS.WRI$_ADV_ACTIONS does not reference any database object

SYS.WRI$_ADV_ACTIONS is referenced by following:

SchemaSYS
ViewDBA_ADVISOR_ACTIONS
ViewDBA_TUNE_MVIEW
Package BodyDBMS_SPACE - show dependent code
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code
Package BodyPRVT_ACCESS_ADVISOR - show dependent code
Package BodyPRVT_ADVISOR - show dependent code
Package BodyPRVT_HDM - show dependent code
Package BodyPRVT_SYS_TUNE_MVIEW - show dependent code
ViewUSER_ADVISOR_ACTIONS
ViewUSER_TUNE_MVIEW
TYPE BODYWRI$_ADV_OBJSPACE_TREND_T
View_DBA_STREAMS_ACTIONS