Skip to Main Content

Database Software

Announcement

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!

Jobs not running : time gap between req_start_date and acutal_start_date

User_A9JA3Nov 17 2022

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.
image.pngI have also checked the job_queue_processes which is 4000 and no MAX_JOB_SLAVE_PROCESSES.
image.pngimage.pngAny ideas?
Thanks.

Comments
Post Details
Added on Nov 17 2022
1 comment
140 views