Mat View - used by?

From: Anthony Ballo <>
Date: Mon, 12 Dec 2011 09:47:15 -0800
Message-ID: <>


I'm trying to determine if we can lengthen the time to refresh on a particular Mat View in Is there a way to see (via SQL?) what other code utilizes this Materialized View (like a "used by")? It is currently on a 1/48 (every half hour) refresh which seems excessive to me.  The naming of the view would suggest that it is used in Discoverer reporting.



Received on Mon Dec 12 2011 - 11:47:15 CST

Original text of this message