| Subject | Re: delete with gc pain | 
|---|---|
| Author | Adam | 
| Post date | 2007-01-24T10:58:22Z | 
> I have a process which does a daily mass delete, I want it to alsoCommit here.
> take all the GC pain. Am I right that if I do
>
> delete from ....
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