5.186 DBA_AUTO_INDEX_CONFIG

DBA_AUTO_INDEX_CONFIG displays the current configuration parameter settings for automatic indexing.

You can set automatic indexing configuration parameters by using the DBMS_AUTO_INDEX.CONFIGURE procedure.

Column Datatype NULL Description

PARAMETER_NAME

VARCHAR2(128)

NOT NULL

Name of the configuration parameter

PARAMETER_VALUE

VARCHAR2(4000)

Value of the configuration parameter

PARAMETER_VALUE_CLOBFoot 1

CLOB

  

Value of the configuration parameter, in CLOB format

LAST_MODIFIED

TIMESTAMP(6)

Time at which the parameter value was last modified

MODIFIED_BY

VARCHAR2(128)

User who last modified the parameter value

Footnote 1 This column is available starting with Oracle Database 23ai, Release Update 23.7.

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_AUTO_INDEX.CONFIGURE procedure