OraFAQ Forum: Replication » HOW to check the refresh rate of existing MView

Home » Server Options » Replication » HOW to check the refresh rate of existing MView

Thu, 28 January 2010 01:37

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

Thu, 28 January 2010 01:41

Michel Cadot
Messages: 68641
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

Thu, 28 January 2010 01:44

shalley.chopra
Messages: 3
Registered: January 2010
Location: delhi

Junior Member

Can U please give me the complete query? eg MV name is "ABC"

Thu, 28 January 2010 01:46

shalley.chopra
Messages: 3
Registered: January 2010
Location: delhi

Junior Member

How often a refresh occur..

Thu, 28 January 2010 02:03

Michel Cadot
Messages: 68641
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: Wed Apr 17 20:22:38 CDT 2024