Question: What is the advantage of using more
than one redo log thread?
By Steve Callan: In RAC, there are no advantages to
using more than one thread. That's just how Oracle works in a
multiple instance architecture such as RAC.
instance/single database means the redo logs form one thread, so
there is no difference between a thread and the redo log. Multiple
instance architecture = each instance has its own set of redo logs
and forms a thread of those therein.
Also see these important notes on
Oracle RAC redo log thread management.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.