Re: Advanced Queue ordering?

Steve, thanks for the nice explanation.

If you think about it, there will always be a finite time interval between the enqueue and the commit.

Hence there is always that element of chance for the session that did the enqueue first with the lower priority (from a sequence.nextval) to commit AFTER the session that did the enqueue later on (with a higher sequence.nextval).

what this means is that the only way to guarantee the global order is to have the enqueue and the commit run in a "mutex" across sessions.

which again may not be practical.

Thanks, Karthik

--
http://www.freelists.org/webpage/oracle-l