Re: MV's monitoring

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 12 Jan 2014 11:49:08 -0800
Message-ID: <CAORjz=OHDUrHa1vTb5F-HxuAPQH4ZkZSeyfLbPVn0hDw+kpmAA_at_mail.gmail.com>

Fine Grained Auditing would be the most accurate method.

Periodically sampling v$sqlstats is another.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Mon, Dec 23, 2013 at 1:44 PM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> Hi
>
> Do we know any best way to check if a particular MV's is been used in last
> couple of days. I know that we can enable monitoring on Table level to
> check it but look like this is not valid for MV's . I think one solution
> can be audit on select on MV and keep monitoring aud$. Any more suggestions
> are appreciated.
>
> TIA
> Sanjay
>

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

Received on Sun Jan 12 2014 - 20:49:08 CET