V$OBJECT_USAGE

V$OBJECT_USAGE displays statistics about index usage gathered from 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.

Column	Datatype	Description
`INDEX_NAME`	`VARCHAR2(30)`	Index name in sys.obj$.name
`TABLE_NAME`	`VARCHAR2(30)`	Table name in sys.obj$.name
`MONITORING`	`VARCHAR2(3)`	`YES`\| `NO`
`USED`	`VARCHAR2(3)`	`YES`\| `NO`
`START_MONITORING`	`VARCHAR2(19)`	Start monitoring time in `sys.object_stats.start_monitoring`
`END_MONITORING`	`VARCHAR2(19)`	End monitoring time in `sys.object_stats.end_monitoring`