Re: Materialized views
From: David Aldridge <david_at_david-aldridge.com>
Date: Mon, 7 Mar 2011 03:51:17 -0800 (PST)
Message-ID: <67068.23615.qm_at_web801.biz.mail.mud.yahoo.com>
Date: Mon, 7 Mar 2011 03:51:17 -0800 (PST)
Message-ID: <67068.23615.qm_at_web801.biz.mail.mud.yahoo.com>
I'd guess that you might try turning on monitoring for the MV's base table and check user_tab_modifications after each refresh (flushing the stats beforehand). ________________________________ From: Rajesh Kella <rajesh.kella_at_gmail.com> To: oracle-l_at_freelists.org Sent: Mon, 1 November, 2010 21:37:38 Subject: Materialized views Does anyone monitor the materialized views for Master-Destination databases or is there a way to measure the throughput of data being replicated between databases ideas and scripts will be appreciated -- Thanks Kella Rajesh
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 07 2011 - 05:51:17 CST