For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I have a job that refreshes materialized views, but failed to run on the period of every 30 minutes. The difference between "REQ_START_DATE" and "ACUTUAL_START_DATE" might vary from seconds to hours, and that could lead to not executing the next run since it consider that this job is still running. I have also checked the job_queue_processes which is 4000 and no MAX_JOB_SLAVE_PROCESSES. Any ideas? Thanks.