Home » Server Options » RAC & Failsafe » log parallelism in Oracle RAC (Oracle 9i,10g)
log parallelism in Oracle RAC [message #398757] Fri, 17 April 2009 07:52 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi All,
how can we enable log parallelism in Oracle RAC?
how can we check if it is already enabled ?


thanks in advance

Report message to a moderator

Re: log parallelism in Oracle RAC [message #398766 is a reply to message #398757] Fri, 17 April 2009 08:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You may want to rephrase your question.
There is nothing called as "Log Parallelism" in Oracle.
May be you are talking about parallel operations in backup/recovery with archivedlogs.
May be it is something else.

Report message to a moderator

Re: log parallelism in Oracle RAC [message #398775 is a reply to message #398766] Fri, 17 April 2009 09:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
Parameter                         Description                                    
--------------------------------- -----------------------------------------------
_log_parallelism                  Number of log buffer strands
_log_parallelism_dynamic          Enable dynamic strands
_log_parallelism_max              Maximum number of log buffer strands

All are hidden parameters and should only be modified with the backing of Oracle support.

Regards
Michel

[Updated on: Fri, 17 April 2009 09:01]

Report message to a moderator

Re: log parallelism in Oracle RAC [message #398780 is a reply to message #398757] Fri, 17 April 2009 09:09 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Thanks for the replays

If the _log_parallelism_max is set to one, what can we infer,
what is the default value of _log_parallelism_max

Report message to a moderator

Re: log parallelism in Oracle RAC [message #398781 is a reply to message #398780] Fri, 17 April 2009 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It depends on your version (with 4 decimals), OS, options...
But it is easy to know it: just don't set it.

Regards
Michel

Report message to a moderator

Re: log parallelism in Oracle RAC [message #398785 is a reply to message #398781] Fri, 17 April 2009 09:26 Go to previous message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Michel, can I infer log parallelism is turned on if _log_parallelism_max is set to one

Report message to a moderator

Previous Topic: RAC Failover : Missing Sessions Reconnected with TAF
Next Topic: OCFS2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 20:21:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.