Re: user_object_usage

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: _at_OracleSK

> Ram Raman <veeeraman_at_gmail.com> 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
> --
 

--
http://www.freelists.org/webpage/oracle-l