OraFAQ Forum: Performance Tuning » Alert log file size can impact database performance

Home » RDBMS Server » Performance Tuning » Alert log file size can impact database performance (10g, 10.2.0.1, window server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alert log file size can impact database performance [message #633031]

Tue, 10 February 2015 06:03

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

Report message to a moderator

Re: Alert log file size can impact database performance [message #633039 is a reply to message #633031]

Tue, 10 February 2015 06:33

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Alert log file size can impact database performance [message #633041 is a reply to message #633039]

Tue, 10 February 2015 06:38

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

Report message to a moderator

Re: Alert log file size can impact database performance [message #633047 is a reply to message #633041]

Tue, 10 February 2015 07:31

cookiemonster
Messages: 13963
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.

Report message to a moderator

Previous Topic:	Updating text string to mask address characters
Next Topic:	Why does monitoring index fix performance?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:56:14 CST 2025