Home » SQL & PL/SQL » SQL & PL/SQL » job runs every 2 minutes, procedure works about 1,5 minutes (Oracle 11g)
icon5.gif  job runs every 2 minutes, procedure works about 1,5 minutes [message #577579] Mon, 18 February 2013 13:23 Go to next message
ecivgamer
Messages: 105
Registered: May 2011
Senior Member
Hi all,

my job runs every 2 minutes, the appropriate procedure works about 1,5 minutes.
It parses log table and inserts some strings into another table for future investigations.
I'm just curious, what would happen if someday the procedure will work longer than 2 minutes?
Is it possible that next job start will lock procedure?
Re: job runs every 2 minutes, procedure works about 1,5 minutes [message #577580 is a reply to message #577579] Mon, 18 February 2013 13:28 Go to previous messageGo to next message
BlackSwan
Messages: 22526
Registered: January 2009
Senior Member
Why don't you change schedule such that it runs every minute to see what happens YOURSELF?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: job runs every 2 minutes, procedure works about 1,5 minutes [message #577744 is a reply to message #577580] Wed, 20 February 2013 01:34 Go to previous messageGo to next message
michael_bialik
Messages: 601
Registered: July 2006
Senior Member
And if you want to ensure 'single thread' processing - look at DBMS_LOCK package
Re: job runs every 2 minutes, procedure works about 1,5 minutes [message #577746 is a reply to message #577744] Wed, 20 February 2013 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If there is only one job there is no risk to have several processes processing.

Regards
Michel
Re: job runs every 2 minutes, procedure works about 1,5 minutes [message #577806 is a reply to message #577746] Wed, 20 February 2013 15:28 Go to previous message
Bill B
Messages: 1068
Registered: December 2004
Senior Member
If a specific job is scheduled for every minute and it took three minutes to run, It would run for three minutes and then run against at the next minute interval. It will not run multiple times at the same time.
Previous Topic: oracle pl/sql
Next Topic: Data_Validation_In_Pl/SQL
Goto Forum:
  


Current Time: Wed Jul 30 02:37:45 CDT 2014

Total time taken to generate the page: 0.07810 seconds