12.1.0.2 RAC and redo log threads
Hi all
According to the notes I've read, a RAC instance has a unique thread number and a redo log thread will belong to that particular instance.
I have queried by 2-node RAC database and found that the redo log threads actually can belong to both instances.
Has this changed in 12.1.0.2 or did I misunderstand the RAC redo log threading concept?
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
CWXDB1
SQL> sho parameter thread
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_threads_per_cpu integer 2
thread integer 1
threaded_execution boolean FALSE
SQL> select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log;