Home » SQL & PL/SQL » SQL & PL/SQL » MATERIALIZED VIEW REFRESH HISTORY (Oracle Database 12c Enterprise Edition Release - 64bit Production)
MATERIALIZED VIEW REFRESH HISTORY [message #679588] Tue, 10 March 2020 09:42 Go to next message
Messages: 237
Registered: March 2008
Location: Delhi
Senior Member
Hi All,

I want to know Materialized View Refresh History like when refresh happened how much time it took whether complete refresh or fast refresh happened etc.

Is there any way I can find it in oracle.

I searched a lot but could not find it anywhere although I can find this information only related to last refresh in few views.

Re: MATERIALIZED VIEW REFRESH HISTORY [message #679627 is a reply to message #679588] Wed, 11 March 2020 07:18 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
If you are using a scheduled job to do the refresh the information your looking for will be in the jobs logs.
Previous Topic: multiple inserts without Loops
Next Topic: Locking issue while MATERIALIZED VIEW REFRESH
Goto Forum:

Current Time: Sun Jun 13 12:30:27 CDT 2021