Mat View - used by?

From: Anthony Ballo <anthony.ballo_at_onecall.com>
Date: Mon, 12 Dec 2011 09:47:15 -0800
Message-ID: <CB0B7CAC.15334%anthony.ballo_at_onecall.com>

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

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

This message: [ Message body ]
Next message: Tim Gorman: "Re: Mat View - used by?"
Previous message: sundar mahadevan: "Re: Automate rman login with shell script"
In reply to: Herring Dave - dherri: "RE: Using WGET for Oracle Patches - (Was "Fun with WAIT Event "library cache: mutex X")"
Next in thread: Tim Gorman: "Re: Mat View - used by?"
Maybe reply: Tim Gorman: "Re: Mat View - used by?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message