Re: limit alertSID.log file size

Are you sure it is a safe method to rotate the alertSID.log file?

Since the instance is not shut down after the "mv", its processes still hold the old file open. When they need to write an alert, it is written to the new alertSID.log but they hold both files open. Test done on Aix and Linux. It's not a big deal but there must be better ways to do it. Joel suggested rotatelogs but apparently it's meant to be used with piped logs and oracle does not provide this functionality for alertSID.log afaik.

A clean solution may be to used a named pipe alertSID.log at the os level and have a script manage its I/O (I haven't tried that.)

Vitalis

-- 
Message posted via http://www.oraclemonster.com