Home » RDBMS Server » Server Administration » log_archive_max_processes parameter
log_archive_max_processes parameter [message #316408] Fri, 25 April 2008 00:51 Go to next message
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,
Re: log_archive_max_processes parameter [message #316411 is a reply to message #316408] Fri, 25 April 2008 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: log_archive_max_processes parameter [message #316415 is a reply to message #316411] Fri, 25 April 2008 01:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it!

Regards
Michel
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:
  


Current Time: Mon Dec 05 21:05:48 CST 2016

Total time taken to generate the page: 0.09964 seconds