Home » RDBMS Server » Server Administration » Refresh group for Materialized views monitoring
Refresh group for Materialized views monitoring [message #417065] Wed, 05 August 2009 19:54 Go to next message
ephremm
Messages: 2
Registered: February 2009
Junior Member
i was wonder one can go by get a notification email from the system when refresh group is compeleted refreshing the MVs.
Re: Refresh group for Materialized views monitoring [message #417068 is a reply to message #417065] Wed, 05 August 2009 20:23 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed
Re: Refresh group for Materialized views monitoring [message #418316 is a reply to message #417065] Fri, 14 August 2009 02:39 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I don't know of an automatic way of doing it. If you're refeshing them manually then you could add a call to Utl_Mail at the emd of the refresh code.

@BlackSwan - thanks for another totaly help free post.
I wonder if you could point to the parts of the posting guidelines that you feel the OP failed to comply with?
Re: Refresh group for Materialized views monitoring [message #418401 is a reply to message #418316] Fri, 14 August 2009 12:54 Go to previous message
ephremm
Messages: 2
Registered: February 2009
Junior Member
thank you very much for the response, i was thinking to do that as well.
Previous Topic: Error in alert log
Next Topic: stack space in shared server configuration
Goto Forum:
  


Current Time: Wed Dec 07 02:57:55 CST 2016

Total time taken to generate the page: 0.11589 seconds