Mat View - used by?

  • From: Anthony Ballo <anthony.ballo@xxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 12 Dec 2011 09:47:15 -0800

Hello,

I'm trying to determine if we can lengthen the time to refresh on a
particular Mat View in 10.2.0.4. 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.


Thanks,

Anthony

--
http://www.freelists.org/webpage/oracle-l


Other related posts: