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!

will any default settings kill a long running PL/SQL stored procedure?

temApr 13 2012 — edited Apr 13 2012

Hi, I'll be using a DBMS_LOCK.SLEEP() statement in a stored procedure as part of a polling loop. As the total execution time for this stored procedure may be large, I wonder whether another process in the database would kill the stored procedure before it is allowed to complete.

Are there any timeout or other conditions I should be concerned about that might cause the stored procedure to stop running if it exceeds a couple hours? If so, how can I access/set these items?

UPDATE:

I reviewed the profile settings for my schema, and since it uses the DEFAULT profile, it appears all settings are essentially UNLIMITED, including CONNECTION TIME and IDLE TIME. So that's good.

Are there any other considerations I should have?

Edited by: tem on Apr 13, 2012 10:38 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2012

Added on Apr 13 2012

#database, #general-database-discussions, #plsql

2 comments

499 views