DBA_AUTO_MV_CONFIG

DBA_AUTO_MV_CONFIG displays configuration parameters associated with automatic materialized views and automatic zone maps.

The configuration parameters displayed in this view can be updated with CONFIGURE procedure of the DBMS_AUTO_MV package.

Column Datatype NULL Description
PARAMETER_NAME VARCHAR2(128) NOT NULL Name of the configuration parameter
PARAMETER_VALUE VARCHAR2(4000)   Value of the configuration parameter
LAST_UPDATED TIMESTAMP(6)   Date and time of the last parameter value update
UPDATED_BY VARCHAR2(128)   User who last updated the parameter value
DESCRIPTION VARCHAR2(72)   Description of the configuration parameter

See Also: Oracle AI Database PL/SQL Packages and Types Reference for more information about the DBMS_AUTO_MV.CONFIGURE procedure