Toad World® Forums

Beta Released (12.11.0.13)

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%.