At 12:03 AM 19/10/2010, Venus Software Operations wrote:

>> COMMIT RETAINING is unrelated to Force write. C-r does commit the work
>> but it holds all the resources open for use by the next transaction.
>> This causes garbage to be held back from clearance indefinitely. If
>> you are performing a full controlled shut-down of the database every
>> day then C-r won't impact things so much.
>>
>
>Oh, these are small sites and server too is shutdown at the end of the
>day. Okay, I found out that I can use gfix to set Forced Writes, but
>where can I see it's current setting?

Repeat, Forced writes is unrelated to Commit Retaining. It is also unrelated to Commit. It is related to i/o, specifically when and whether the OS's i/o cache is written to disk.

./hb