Hey Ram,
we already had a conversation about this "feature" on Twitter and Franck Pachot
created a blog post as a follow-up.
Unfortunately it does not work like we may need/want it.
* https://twitter.com/OracleSK/status/797448446802268160
* https://twitter.com/FranckPachot/status/797846697128919040
* http://blog.dbi-services.com/12cr2-new-index-usage-tracking/
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Ram Raman <veeeraman@xxxxxxxxx> hat am 20. Dezember 2016 um 05:16 geschrieben:
List
Has anyone in the list used 12c dba_object_usage view and found it to be
reliable for monitoring index usage? I remember with the v$obj_usage the
stats were captured that the index was being used even when statistics
collection jobs ran on the index in the nights.
Ram
--