Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$OBJECT_USAGE

V$OBJECT_USAGE displays statistics about index usage gathered from the database for the indexes owned by the current user. 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.

Note:

The V$OBJECT_USAGE view is deprecated in Oracle Database 12c Release 1 (12.1) and maintained for backward compatibility. Support for this view may be removed in a future release. Oracle recommends that you use the USER_OBJECT_USAGE view instead of the V$OBJECT_USAGE view.
Column Datatype NULL Description
INDEX_NAME VARCHAR2 NOT NULL Index name in sys.obj$.name
TABLE_NAME VARCHAR2 NOT NULL Table name in sys.obj$.name
MONITORING VARCHAR2   YES| NO
USED VARCHAR2   YES| NO
START_MONITORING VARCHAR2   Start monitoring time in sys.object_stats.start_monitoring
END_MONITORING VARCHAR2   End monitoring time in sys.object_stats.end_monitoring