can we stop to record log switch in Alert.log?

[patnams]

Hi All,

Is there a way to stop log switched to record in Alert.Log.
The file is growing very fast to lot of log switches.

Thanks
Sridhar

[gandolf989]

Maybe the problem is that you are doing too many log switches not that the alert log is filling up. If you use Unix you can probably create a shell script that runs in a cron to either delete the alert log of rename and compress. Oracle will recreate the file, empty and start filling it again. Depending on the amount of DML if you are doing more than 20-30 log switches an hour during peak utilization you may want to increase the size of the log files. You may also want to add additional log groups. There are scripts that give you information in waits on this site that might give you some insight. I'm not sure how you suppress the log switch message in the alert log or why you would want to. That is one way of looking at how busy your database is and that it is doing what it is supposed to be doing. There are many other ways of finding out if your database is working properly of course.

[patnams]

Thanks for the info .. I'll write scripts to manager Alert.Log

[Raminder]

There is no way to stop Oracle from recording log switch in Alert log. Your database is experiencing high DML activity, so you can think about increasing the size of online redologs.
However, you must remember the downfall, checkpoints can occur less frequently, causing higher recovery time if you have not tuned other aspects to take care of recovery time (like checkpoint interval).

Originally quoted by gandolf989:

......You may also want to add additional log groups.....

How will adding additional log groups affect number of log switches??

[Calvin_Qiu]

Originally posted by Raminder
Originally quoted by gandolf989:
How will adding additional log groups affect number of log switches??

I imagine that Gandolf meant that adding additional log groups would give more time to ARC process to do archive jobs since 20-30 logfile switchs per hour.

[Raminder]

Originally posted by Calvin_Qiu:

quote:
--------------------------------------------------------------------------------
Originally posted by Raminder
Originally quoted by gandolf989:
How will adding additional log groups affect number of log switches??
--------------------------------------------------------------------------------

I imagine that Gandolf meant that adding additional log groups would give more time to ARC process to do archive jobs since 20-30 logfile switchs per hour

I think the problem posed by Patnams was about the fast fill of alert log due to log switches.