Home » RDBMS Server » Performance Tuning » Cycling alert log
Cycling alert log [message #65561] Thu, 28 October 2004 06:27 Go to next message
Vasco Saavedra
Messages: 3
Registered: October 2004
Junior Member
Is there any way off defining a maximum size from which oracle automatic creates a new alert log?


Or the alert log grows constantly for ever?


Thanks in advance for your answers !!
Re: Cycling alert log [message #65562 is a reply to message #65561] Thu, 28 October 2004 07:28 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it will grow for ever.
it is not a good idea to restrict it with some hard-file size limit.

You can have a simple monitor to keep an eye on size and report you /rotoate the log if it execeeds your limit or rotate the logs in some timely fashion .

try some rotate log scripts.
You can use anything you want.
I googled and found this ( i would use much simpler one...)

Previous Topic: Database Buffer Cache
Next Topic: Can I lock SGA in RAM
Goto Forum:

Current Time: Wed Feb 28 13:16:40 CST 2024