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 >