[Home] [Help]
[Dependency Information]
TABLE: SYS.WRI$_ADV_PARAMETERS
Object Details
Object Name: | WRI$_ADV_PARAMETERS |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: WRI$_ADV_PARAMETERS_PK
- TASK_ID
- NAME
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
WRI$_ADV_PARAMETERS_PK
|
NORMAL
|
UNIQUE
|
SYSAUX
|
TASK_ID
NAME
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TASK_ID |
NUMBER |
|
Yes |
|
NAME |
VARCHAR2 |
(128) |
Yes |
|
VALUE |
VARCHAR2 |
(4000) |
Yes |
|
DATATYPE |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
DESCRIPTION |
VARCHAR2 |
(9) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, NAME
, VALUE
, DATATYPE
, FLAGS
, DESCRIPTION
FROM SYS.WRI$_ADV_PARAMETERS;
Dependencies
[top of page]
SYS.WRI$_ADV_PARAMETERS does not reference any database object
SYS.WRI$_ADV_PARAMETERS is referenced by following:
-
SYS
-
DBA_ADVISOR_EXEC_PARAMETERS
-
DBA_ADVISOR_PARAMETERS
-
DBA_ADVISOR_PARAMETERS_PROJ
-
DBA_ADVISOR_SQLW_PARAMETERS
-
DBMS_ADVISOR
- 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_WORKLOAD
- show dependent code
-
USER_ADVISOR_EXEC_PARAMETERS
-
USER_ADVISOR_PARAMETERS
-
USER_ADVISOR_SQLW_PARAMETERS
-
WRI$_ADV_COMPRESSION_T
-
WRI$_ADV_OBJSPACE_TREND_T