Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle dbms_scheduled actual start date differing from requested start date

user5716448Aug 8 2022

Hi,

version 11.2.03.

We have various scheduled jobs and can see sometimes variable delay between request start date and actual start date can be few minutes but sometimes over an hour. Often start when requested but varies.

When look at OEM can see database quite busy often but not maxed out in terms of cpu/i-o

Any thoughts considerations into trying to ensure interval between req start date and actual start date as close as possible. Try and encourage users to spread out their jobs.

What are typical specific causes of delay etween request start date and actual start date

Jobs themselves run within the window allotted so not overlapping.

Thanks

Comments
Post Details
Added on Aug 8 2022
8 comments
809 views