Home » Server Options » Replication » HOW to check the refresh rate of existing MView
HOW to check the refresh rate of existing MView [message #440952] Thu, 28 January 2010 01:37 Go to next message
shalley.chopra
Messages: 3
Registered: January 2010
Location: delhi
Junior Member

Hi thr

Please tell me hw can i check the refresh rate of existing Mview..

With Regards
Re: HOW to check the refresh rate of existing MView [message #440957 is a reply to message #440952] Thu, 28 January 2010 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "refresh rate".
How often a refresh occurs or how long a refresh lasts?

Regards
Michel
Re: HOW to check the refresh rate of existing MView [message #440958 is a reply to message #440957] Thu, 28 January 2010 01:44 Go to previous messageGo to next message
shalley.chopra
Messages: 3
Registered: January 2010
Location: delhi
Junior Member

Can U please give me the complete query? eg MV name is "ABC"
Re: HOW to check the refresh rate of existing MView [message #440959 is a reply to message #440957] Thu, 28 January 2010 01:46 Go to previous messageGo to next message
shalley.chopra
Messages: 3
Registered: January 2010
Location: delhi
Junior Member

How often a refresh occur..
Re: HOW to check the refresh rate of existing MView [message #440962 is a reply to message #440959] Thu, 28 January 2010 02:03 Go to previous message
Michel Cadot
Messages: 58597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check column INTERVAL in DBA_JOBS where column WHAT contains your mview name.

Regards
Michel
Previous Topic: Daily refresh at particular hour/minute
Next Topic: MV referesh error
Goto Forum:
  


Current Time: Mon Jul 28 02:33:05 CDT 2014

Total time taken to generate the page: 0.10984 seconds