Alex,

> >
> > Suppose I have exclusive access to my db, theoretically, what
> "should" be
> > the quickest way to achieve a SWEEP : Straight SWEEP or Backup &
> Restore ?
>
> If you mean Oldest Transaction movement and garbage collection - on
> large databases usually sweep (if there are not TONS of garbage and
> transactions gap is'nt measured in millions).

Yes, something like this.

> For example, my 8Gb
> database having several thousands gap is nightly sweeped in ~10
> minutes, backup process require ~30 minutes and restore ~4 hours.

Great ! My db is about the same size and I was a bit surprised by similar
figures. Good to know everything "seems" ok.

Thanks.

--
Jerome