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


TABLE: SYSTEM.MVIEW$_ADV_PARAMETERS

Object Details
Object Name: MVIEW$_ADV_PARAMETERS
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Summary advisor tuning parameters

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_PARAMETERS_PK
  1. ColumnPARAMETER_NAME
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_PARAMETERS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPARAMETER_NAME
Columns
Name Datatype Length Mandatory Comments
PARAMETER_NAME VARCHAR2 (128) Yes
PARAMETER_TYPE NUMBER
Yes
STRING_VALUE VARCHAR2 (30)
DATE_VALUE DATE

NUMERICAL_VALUE NUMBER

Query Text

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;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_PARAMETERS does not reference any database object

SYSTEM.MVIEW$_ADV_PARAMETERS is not referenced by any database object