MV's monitoring

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 23 Dec 2013 13:44:16 -0800 (PST)

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: