DBA_INDEX_USAGE
DBA_INDEX_USAGE displays cumulative statistics for each index.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OBJECT_ID |
NUMBER |
NOT NULL |
Object ID for the index |
NAME |
VARCHAR2(128) |
NOT NULL |
Index name |
OWNER |
VARCHAR2(128) |
NOT NULL |
Index owner |
TOTAL_ACCESS_COUNT |
NUMBER |
Total number of times the index has been accessed | |
TOTAL_EXEC_COUNT |
NUMBER |
Total executions the index has participated in | |
TOTAL_ROWS_RETURNED |
NUMBER |
Total rows returned by the index. Index usage is categorized into buckets of different ranges. Each bucket has a range of values for access count and rows returned. An entry is placed into a bucket if the rows returned or access counts falls within the range of that bucket. |
|
BUCKET_0_ACCESS_COUNT |
NUMBER |
The index has not been accessed | |
BUCKET_1_ACCESS_COUNT |
NUMBER |
The index has been accessed once | |
BUCKET_2_10_ACCESS_COUNT |
NUMBER |
The index has been accessed between 2 and 10 times | |
BUCKET_2_10_ROWS_RETURNED |
NUMBER |
The index has returned between 2 and 10 rows | |
BUCKET_11_100_ACCESS_COUNT |
NUMBER |
The index has been accessed between 11 and 100 times | |
BUCKET_11_100_ROWS_RETURNED |
NUMBER |
The index has returned between 11 and 100 rows | |
BUCKET_101_1000_ACCESS_COUNT |
NUMBER |
The index has been accessed between 101 and 1000 times | |
BUCKET_101_1000_ROWS_RETURNED |
NUMBER |
The index has returned between 101 and 1000 rows | |
BUCKET_1000_PLUS_ACCESS_COUNT |
NUMBER |
The index has been accessed more than 1000 times | |
BUCKET_1000_PLUS_ROWS_RETURNED |
NUMBER |
The index has returned more than 1000 rows | |
LAST_USED |
DATE |
Time that the index was last used |
See Also: “V$INDEX_USAGE_INFO”