Beta Notes:
Index Usage
Oracle 12cR2 has a new feature to track index usage. A tab to support it has been added to SB-Indexes-RHS. There are a couple of things to keep in mind with this feature: Data comes from V$INDEX_USAGE_INFO and DBA_INDEX_USAGE. There is no ALL_ or USER_ version of this view. So it won’t be available to lower-privileged users. Also, Oracle takes samples to collect this data, so it’s not 100%.