SQL> select GROUP#,THREAD# ,SEQUENCE# from v$log;
GROUP# THREAD# SEQUENCE#
---------- ---------- ----------
1 1 5
2 1 6
3 2 3
4 2 4
上图中能看到 thread 1和thread 2,难道一个实例有两个thread?
v$ 视图是查询单个节点的动态视图的,但是对于redo和datafile ,每个节点可以访问所有节点的情况
SQL> select INST_ID,GROUP#,THREAD# ,SEQUENCE# from gv$log;
INST_ID GROUP# THREAD# SEQUENCE#
---------- ---------- ---------- ----------
1 1 1 5
1 2 1 6
1 3 2 3
1 4 2 4
2 1 1 5
2 2 1 6
2 3 2 3
2 4 2 4
8 rows selected.
每个日志组有两个成员,每个实例管理2个 日志组。
SQL> show parameter instance_name
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
instance_name string
orcl2
SQL> show parameter instance_number
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
instance_number integer
2
SQL> show parameter thread
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
parallel_threads_per_cpu integer
2
thread integer
2