davemac330 wrote:

>>>I am watching a gfix -sweep which has been running for nearly two
>>>hours. It's coming up to 6am and I need to bring the site back up. Is
>>>it safe to kill this process?
>>
>>If the database is in shutdown, you can bring it back online while the
>>sweep is running. It would be a shame to lose two hours' worth of
> garbage cleanup.
>
> Thanks for the quick response.
>
> I'm a bit worried that it's taking a lot of CPU (100% of one CPU in a
> dual Xeon box running Red Hat 9). I've brought the site up now and the
> database is OK, however, I'd like that gfix process not to be there.

I run sweep overnight as well - after the daily backup, but I wonder if
it would not be better to run it on it's inline trigger in some
circumstances. A blip every hour rather than an almighty gap at night?
In my case it's still only a minute or two a night, but it is something
that needs a think about.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services