[Home] [Help]
[Dependency Information]
TABLE: SYS.WRI$_ADV_DEFINITIONS
Object Details
Object Name: | WRI$_ADV_DEFINITIONS |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: WRI$_ADV_DEFINITIONS_PK
- ID
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
WRI$_ADV_DEFINITIONS_PK
|
NORMAL
|
UNIQUE
|
SYSAUX
|
ID
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
NUMBER |
|
Yes |
|
NAME |
VARCHAR2 |
(128) |
Yes |
|
PROPERTY |
NUMBER |
|
Yes |
|
TYPE |
WRI$_ADV_ABSTRACT_T |
(256) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, PROPERTY
, TYPE
FROM SYS.WRI$_ADV_DEFINITIONS;
Dependencies
[top of page]
SYS.WRI$_ADV_DEFINITIONS references the following:
-
SYS
-
STANDARD
- show dependent code
-
WRI$_ADV_ABSTRACT_T
-
WRI$_ADV_COMPRESSION_T
-
WRI$_ADV_HDM_T
-
WRI$_ADV_OBJSPACE_TREND_T
-
WRI$_ADV_SPM_EVOLVE
-
WRI$_ADV_SQLACCESS_ADV
-
WRI$_ADV_SQLPI
-
WRI$_ADV_SQLTUNE
-
WRI$_ADV_TUNEMVIEW_ADV
-
WRI$_ADV_UNDO_ADV
-
WRI$_ADV_WORKLOAD
SYS.WRI$_ADV_DEFINITIONS is referenced by following:
-
SYS
-
DBA_ADVISOR_DEFINITIONS
-
DBA_ADVISOR_DEF_PARAMETERS
-
DBA_ADVISOR_DIR_DEFINITIONS
-
DBA_ADVISOR_EXECUTION_TYPES
-
DBA_ADVISOR_FINDING_NAMES
-
DBA_ADVISOR_USAGE
-
PRVT_ACCESS_ADVISOR
- show dependent code
-
PRVT_ADVISOR
- show dependent code