On Friday, December 10, 2004, 11:37:59 PM, Ann W. Harrison wrote:

> At 06:08 AM 12/10/2004, Bambang P wrote:

>>Does Rollback leave garbage?

> That depends - an ordinary rollback under program control tries
> to clean up after itself. Rollback caused by an abnormal event -
> program or server crash for example - leaves stuff in the database
> for later cleanup.

So this means, the message which I was referring below is not all
right (the "Avoid Rollback" part). Thanks for your clarification.

<Quote>

>3) What can I do to eliminate both? I know how to eliminate sweep,
>but seems like that's a problem, too. So I'd have to turn it on and
>off in batch process at night or something?

Commit transaction as soon as possible. Avoid XXXRetaining. Avoid
rollback.
</EndQuote>


--
Bambang
http://bpranoto.tripod.com


"I am NOT going to use a $20 million missile to blow up a $10 empty tent
and hit a camel in the butt." - George Bush, Sept 16, 2001