V$INDEX_USAGE_INFO keeps track of index usage since the last flush. A flush occurs every 15 minutes. After each flush, ACTIVE_ELEM_COUNT is reset to 0 and LAST_FLUSH_TIME is updated to the current time.
Indicates whether the index usage statistics are enabled. Possible values:
0: Index statistics are disabled
1: Index statistics are enabled
Indicates the type of collection used for the index usage statistics. Possible values:
0: Indicates the ALL collection type. With this type of collection, the statistics are collected for each execution that has index access. Selecting this statistics collection type may have some impact on performance.
1: Indicates the SAMPLED collection type. With this type of collection, the statistics are collected based on sampling (only a few of the executions are considered when collecting the statistics). This is the default statistics collection type.
Index statistics collected with the SAMPLED collection type are less accurate than index statistics collected with the ALL collection type.
The number of active indexes since the last flush
The number of index entries allocated
The maximum number of active indexes that can be tracked
Number of successful flushes since the database started
Cumulative elapsed time taken to complete the index usage statistics flush since the database start
The time of the last flush
Status messages, if any. Flush errors are reported here.
The ID of the container to which the data pertains. Possible values include:
0: This row is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data
This view is available starting with Oracle Database 12c Release 2 (18.104.22.168).