> According to our DBA a sweep is being run nightly.
> on the database how could then "The gap" be over a million?

a) this million may be accumulated since last successful sweep
b) there was active transaction(s) during last sweep preventing it to adance OIT
c) sweep was aborted

Regards,
Vlad