OraFAQ Forum: Server Administration » log_archive_max

Home » RDBMS Server » Server Administration » log_archive_max_processes parameter

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

log_archive_max_processes parameter [message #316408]

Fri, 25 April 2008 00:51

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Hi,
Yesterday there was heavy network traffic on the application and application was also slows down.

Thats why i changed parameter

log_archive_max_processes = 2 ----->log_archive_max_processes =3

Was i right?

Now if i will change,

log_archive_max_processes = 3 ----->log_archive_max_processes =2

What will be impact on the database?
Your thaughts will highly appreciated.

Thanks,

Report message to a moderator

Re: log_archive_max_processes parameter [message #316411 is a reply to message #316408]

Fri, 25 April 2008 00:55

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

Senior Member
Account Moderator

Quote:

Thats why i changed parameter

log_archive_max_processes = 2 ----->log_archive_max_processes =3

Was i right?

No. Why did you change that?

If network traffic slows down application either work on network (increase bandwidth) or on application (decrease network roundtrips or exchanged bytes).

Regards
Michel

Report message to a moderator

Re: log_archive_max_processes parameter [message #316415 is a reply to message #316411]

Fri, 25 April 2008 01:01

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Thanks Michel,

Means changing log_archive_max_processes doenst effect to increease performance in case of many requests?

And should i change log_archive_max_processes = 2 from 3?
What will impact on the database?

Thanks.

[Updated on: Fri, 25 April 2008 01:04]

Report message to a moderator

Re: log_archive_max_processes parameter [message #316419 is a reply to message #316408]

Fri, 25 April 2008 01:38

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Now on the application end there are less requests.

So i should change log_archive_max_processes parameter from 3 to 2.

But please confirm will it impact anything on the database or any other consequences.

Thanks,

[Updated on: Fri, 25 April 2008 01:39]

Report message to a moderator

Re: log_archive_max_processes parameter [message #316452 is a reply to message #316419]

Fri, 25 April 2008 03:01

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

Senior Member
Account Moderator

Do it!

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle10g update patch set p5337014_10203_LINUX.zip fail?
Next Topic:	Getting this below error while trying to recreate a tablespace if the file already exists

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 21:53:38 CST 2024