Subject Re: delete with gc pain
Author Adam
> I have a process which does a daily mass delete, I want it to also
> take all the GC pain. Am I right that if I do
>
> delete from ....

Commit here.

Now you need to wait for all transactions that could have been
interested in the record versions prior to the delete to end (ie
commit/rollback).

Now nothing else is interested, the next transaction to read the
record is given the task of cleaning it up, so your next line is fine

> select count(*) from ...

Remember to commit here.

Adam