Home » SQL & PL/SQL » SQL & PL/SQL » Materialize View (10g)
Materialize View [message #446814] Wed, 10 March 2010 10:01 Go to next message
Messages: 90
Registered: July 2005
I want to trace the time it takes to refresh the MV for the last few runs. How can i find that? The MV runs every 7 hours..for the last few times it runs, I would like to trace the time it took to complete.

thanks for your help
Re: Materialize View [message #446815 is a reply to message #446814] Wed, 10 March 2010 10:08 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing for this you have to do it manually:
- change your mview to a refresh on demand
- create a procedure that will refresh the mview (and take the times)
- create a job which will execute the procedure at the same frequency than previously your mview

Previous Topic: Trigger
Next Topic: Error Reading A File
Goto Forum:

Current Time: Sun Jul 23 22:24:57 CDT 2017

Total time taken to generate the page: 0.17349 seconds