Database Administration (MOSC)

MOSC Banner

Scheduler Job overrunning intermittently

edited Oct 2, 2012 9:01AM in Database Administration (MOSC) 8 commentsAnswered

Hello Experts,

   I have a scheduler Job(which runs a Procedure and this procedure has one INSERT statement) that is expected to run 3-4 mins, most of the days it runs as expected, Hoever suddenly it over runs for 4-5 Hrs and never completes successfully, Even I stop the Job and rerun it it will keep running. During those days I have to stop relying on running job rather run the INSERT statement as is. It will execute in the expected 3-4 Mins.

   I couldnt see anything any abnormal in the AWR reports, nor any locks.

   The count of Job_queue_processes in the database is 10 and at this time of the morning only this Job runs in the database, not sure if these processes are causing any problem.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center