Re: MV's monitoring
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Sanjay Mishra <smishra_97@xxxxxxxxx>
- Date: Sun, 12 Jan 2014 11:49:08 -0800
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@xxxxxxxxx> 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
>
Other related posts:
