This content has been marked as final. Show 3 replies
check system parameter job_queue_processes is must be > 0.1 person found this helpful
Check dba_jobs for job where what contain dbms_mview.refresh for your MV_BU.
If job exists and job_queue_processes > 0 then check failures. When non zero value is there than job failing when it is runnig so look in alert.log where you find info why job failed.
Can you please let me know where to find alter.log file.
I have set job_queue_processes =20 and 2 of my MVs are refreshing fine. But another 2 are broken. When I run manually, they work fine but in nothing they go back to broken status as it fails for 16 times.
Thanks in advance.