Home » RDBMS Server » Performance Tuning » Alert log file size can impact database performance (10g, 10.2.0.1, window server 2008)
Alert log file size can impact database performance [message #633031] Tue, 10 February 2015 06:03 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

One of the database is having alert log of size 400Mb.

Though, we can rename it. Oracle will create the new one. But writing on same alert log would impact any performance issue?

Please provide your valuable inputs on it.

Thanks,

Regards,
Ashish Kumar Mahanta
Re: Alert log file size can impact database performance [message #633039 is a reply to message #633031] Tue, 10 February 2015 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 66057
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Nothing that can be measurable.
But it is however recommended to split the file then if you have a problem with it (io error) you won't lose the whole data.

Re: Alert log file size can impact database performance [message #633041 is a reply to message #633039] Tue, 10 February 2015 06:38 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Thanks Michel,

I was having doubt on it. Now, it's clear. It's always recommended to split the file to smaller one.

Regards,
Ashish Kumar Mahanta
Re: Alert log file size can impact database performance [message #633047 is a reply to message #633041] Tue, 10 February 2015 07:31 Go to previous message
cookiemonster
Messages: 13394
Registered: September 2008
Location: Rainy Manchester
Senior Member
And even if you don't have io errors etc opening and reading a 400M file in most text editors is a pain.
Previous Topic: Updating text string to mask address characters
Next Topic: Why does monitoring index fix performance?
Goto Forum:
  


Current Time: Tue Dec 18 17:02:32 CST 2018