Re: user_object_usage

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 21 Dec 2016 14:12:16 -0600
Message-ID: <CAHSa0M0Y6hnHvTuSGFXvRbGzE3ORMXVWmzzM7p-QooO3ViFDcA_at_mail.gmail.com>



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_at_soocs.de> 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: _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
Received on Wed Dec 21 2016 - 21:12:16 CET

Original text of this message