[Home] [Help]
[Dependency Information]
Object Name: | MVIEW$_ADV_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Summary advisor tuning parameters
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MVIEW$_ADV_PARAMETERS_PK | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAMETER_NAME | VARCHAR2 | (128) | Yes | |
PARAMETER_TYPE | NUMBER | Yes | ||
STRING_VALUE | VARCHAR2 | (30) | ||
DATE_VALUE | DATE | |||
NUMERICAL_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PARAMETER_NAME
, PARAMETER_TYPE
, STRING_VALUE
, DATE_VALUE
, NUMERICAL_VALUE
FROM SYSTEM.MVIEW$_ADV_PARAMETERS;
SYSTEM.MVIEW$_ADV_PARAMETERS does not reference any database object
SYSTEM.MVIEW$_ADV_PARAMETERS is not referenced by any database object
|
|
|