DBA_OBJECT_USAGE
DBA_OBJECT_USAGE displays statistics about index usage gathered from the database for all the indexes in the database.
You can use this view to monitor index usage. All indexes that have been used at least once can be monitored and displayed in this view.
Related View
USER_OBJECT_USAGEdisplays statistics about index usage gathered from the database for the indexes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Index owner |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Index name in sys.obj$.name |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Table name in sys.obj$.name |
MONITORING |
VARCHAR2(3) |
Indicates whether the monitoring feature is turned on. Possible values:
|
|
USED |
VARCHAR2(3) |
Indicates whether the index has been accessed. Possible values:
|
|
START_MONITORING |
VARCHAR2(19) |
Start monitoring time in sys.object_stats.start_monitoring |
|
END_MONITORING |
VARCHAR2(19) |
End monitoring time insys.object_stats.end_monitoring |
See Also: “USER_OBJECT_USAGE”