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!

Query regarding broken jobs

486215Sep 4 2008 — edited Sep 4 2008

I am using Oracle 10.2.0.2 on Solaris

There are a number of job which run continously every few seconds during deployment and a few of them fail over.
I am facing lock issues in the database so I was wondering if the new sessions created by the DBMS_JOB package would be dropped automatically if the jobs fail and also whether the locks which were used by the jobs would be automatically released?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2008

Added on Sep 4 2008

#general-database-discussions

5 comments

2,007 views