T
TheMadDBA
Guest
George... I think you are correct that most DBAs don't check the log files unless there is a reported issue (and sometimes not even then). I do like the idea of separate logs for different types of messages. Basically the ability to have multiple different log files with their own logging levels and logged events. You could leave the main log intact (or turn off the noise messages like setuserid messages or connect/disconnect) and then have a different log file for errors only. I don't even think you would need another process for this. Just modify the current DB logging processes to honor new parameters. It would certainly cut down on the number of home grown tools to parse all of those out. And when you have very large log files like some of us do it would certainly cut down on the IO parsing those logs.
Continue reading...
Continue reading...