Home » Server Options » Replication » Materialized View Not Refreshing Automatically
Materialized View Not Refreshing Automatically [message #490434] Tue, 25 January 2011 01:37 Go to next message
oraQ
Messages: 57
Registered: January 2011
Member
I am confused to see one materialized view is not refreshing automatically, whereas the same thing I can do manually. Can anyone guide me about this abnormality?
Thanks in advance.
Re: Materialized View Not Refreshing Automatically [message #490436 is a reply to message #490434] Tue, 25 January 2011 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check parameter "job_queue_processes".

Regards
Michel
Re: Materialized View Not Refreshing Automatically [message #511438 is a reply to message #490436] Mon, 13 June 2011 02:03 Go to previous message
deepalismile
Messages: 6
Registered: April 2007
Junior Member
check the schedule of the materialized view refresh job. dba_job_scheduler. It should be schedule properly to refresh MV automatically.
Previous Topic: refreshing snapshots
Next Topic: backup_problem_with_replication
Goto Forum:
  


Current Time: Fri Mar 29 07:04:05 CDT 2024