We have a developer db server with 11g on Windows Server 2003 R2. I just noticed that the
alert_dev11g.log file in the
F:\Oracle11g\diag\rdbms\dev11g\dev11g\trace folder is nearly 4GB large.
I'd like to know if this is a way to delete the log file or dramatically reduce the size of it. I've tried renaming the file, but Windows says that the file is in use by another process.
So far, my research has ended up in many dead ends. Everything I can find on Oracle log files pertains to the redo logs. I found info on the MAX_DUMP_FILE_SIZE parameter, but it excludes the alert file.