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 AI Database 26ai, Release Update 23.7.
See Also: Oracle AI Database PL/SQL Packages and Types Reference for more information about the DBMS_AUTO_INDEX.CONFIGURE procedure