8.4 V$INDEX_USAGE_INFO
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.
Column | Datatype | Description |
---|---|---|
|
|
Indicates whether the index usage statistics are enabled. Possible values:
|
|
|
Indicates the type of collection used for the index usage statistics. Possible values:
|
|
|
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:
|
See Also: