Database Administration (MOSC)

MOSC Banner

12.1.0.2 RAC and redo log threads

edited Mar 8, 2018 5:53PM in Database Administration (MOSC) 4 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center