Alan McDonald wrote:

>>garbage collection causes us some problems--extended and uncontrollable
>>periods when the database works very hard;

>
> set your garbage collection to 0 (i.e. for it not to run automatically) and
> then schedule a backup every night in low use periods. The garbage
> collection is then in your control.

Actually, that's not quite right. If you set the sweep interval to
zero, you control the system-wide complete clean-up. However, garbage
collection happens continuously as a normal part of database processing,
and can cause performance problems, especially if the database includes
indexes on volatile tables that have large numbers (>32,000) instances
of a single key value.

Regards,


Ann