Thank you Stefan. so the problem persists! it seems they packaged the old
wine in a different bottle - calling the view with a different name.
On Tue, Dec 20, 2016 at 10:17 AM, Stefan Koehler <contact@xxxxxxxx> wrote:
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:16geschrieben:
be reliable for monitoring index usage? I remember with the v$obj_usage the
List
Has anyone in the list used 12c dba_object_usage view and found it to
stats were captured that the index was being used even when statisticscollection jobs ran on the index in the nights.
Ram
--