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!

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.

A scheduler job getting hung causing critical issues

orausernMar 28 2014 — edited Mar 28 2014

Hi Experts,

We are on Oracle 11.2.0.2 on Linux. We have some jobs that are scheduled to run at night time like 1 am etc. These jobs copy data from some of the main OLTP tables in the archive tables that are in the same schema. We use PARALLEL hint in this copy sqls. Now most of the times the job finishes in somewhere between 1 to 2 minutes. But yesterday the job was hung for more than 5 hours. It caused outage as the tables got locked and we stopped the job manually to fix the outage. This issues has happened twice thus far - once in a less critical environment and once in production. Today the same job finished in 20 seconds. Could this be due to some bug in scheduler?

I will be thankful for your inputs.

OrauserN

This post has been answered by GregV on Mar 28 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2014

Added on Mar 28 2014

#database-key-features, #scheduler

6 comments

2,671 views