[Home] [Help]
[Dependency Information]
| Object Name: | WRI$_ADV_ACTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | SYSAUX |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
TASK_ID
ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SYS_IL0000363724C00010$$ | LOB | UNIQUE |
SYSAUX
|
|
| SYS_IL0000363724C00011$$ | LOB | UNIQUE |
SYSAUX
|
|
| WRI$_ADV_ACTIONS_PK | NORMAL | UNIQUE |
SYSAUX
|
TASK_ID
ID
|
| 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) |
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;
SYS.WRI$_ADV_ACTIONS does not reference any database object
SYS.WRI$_ADV_ACTIONS is referenced by following:
SYS
DBA_ADVISOR_ACTIONS
DBA_TUNE_MVIEW
DBMS_SPACE
- show dependent code
DBMS_SQLTUNE_INTERNAL
- 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
USER_ADVISOR_ACTIONS
USER_TUNE_MVIEW
WRI$_ADV_OBJSPACE_TREND_T
_DBA_STREAMS_ACTIONS
|
|
|
|