MV's monitoring
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 23 Dec 2013 13:44:16 -0800 (PST)
Message-ID: <1387835056.2735.YahooMailNeo_at_web122102.mail.ne1.yahoo.com>
Hi
Date: Mon, 23 Dec 2013 13:44:16 -0800 (PST)
Message-ID: <1387835056.2735.YahooMailNeo_at_web122102.mail.ne1.yahoo.com>
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-lReceived on Mon Dec 23 2013 - 22:44:16 CET