I'm think of something like this:

process A starts a transaction & holds it open, holding the transaction
counter
(time & transactions pass)
process B starts a transaction, sees gap > 20000 & initiates sweep
process C starts a transaction, sees gap > 20000 & (sweep or why not)?

On 14 January 2013 14:30, Dmitry Kuzmenko <kdv@...> wrote:

> **
>
>
> Hello, Nick!
>
> Monday, January 14, 2013, 5:52:49 PM, you wrote:
>
> NU> if 2 processes both see a gap > 20000 will that result in 2 sweeps
> running
> NU> at the same time?
>
> transaction start is serialized, i.e. no 2 transactions can start at
> the same time. So, auto-sweep can not run 2 times at once.
> Only first transaction start, that will discover "sweep interval",
> will initiate auto-sweep (if it is not turned off by sweep interval =
> 0).
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>
>



--
Nick Upson, Telensa Ltd


[Non-text portions of this message have been removed]