[thelist] Queue processing with a database table.

Luther, Ron Ron.Luther at hp.com
Mon Aug 30 08:57:50 CDT 2010


Bill Moseley asked:

>>Anyway, is there a way to do this other than a full table lock?


Hi Bill,

I liked Hassan's 'daemon' suggestion.  That sounded pretty cool!

On a database-only level, I think you might take a look at row-level locking within transaction blocks.  Not something I fiddle with, but it might be a step in the right direction.

http://www.dba-oracle.com/t_locks_row_level_locking.htm


Good Luck,
RonL.



More information about the thelist mailing list