2020-03-13
单节点ADG环境v$managed_standby中thread#=0和thread#=1的区别及用途是什么？
5M我现在有一套单节点的ADG的环境，我在ADG备库查看 vmanaged_standby时看到有thread#为0和thread#为1的数据，我查看自己的vlog和v$standby_log中只有thread#为1的日志，想咨询一下thread#为0的信息如何产生的？thread#为0和thread#为1的有什么区别？是否能通过在数据库层面修改参数去掉thread#为0的信息？
SYS@enmodg>show parameter thread;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ofs_threads integer 4
parallel_threads_per_cpu integer 2
thread integer 1
threaded_execution boolean FALSE
SYS@enmodg>select PROCESS,PID,STATUS,THREAD#,group#,CLIENT_PID,SEQUENCE# from v$managed_standby order by thread#;
PROCESS PID STATUS THREAD# GROUP# CLIENT_PID SEQUENCE#
--------- ------------------------ ------------ ---------- ---------------------------------------- ---------------------------------------- ----------
RFS 5120 IDLE 0 N/A 4607 0
DGRD 4035 ALLOCATED 0 N/A N/A 0
RFS 5114 IDLE 0 N/A 4595 0
DGRD 4037 ALLOCATED 0 N/A N/A 0
RFS 5118 IDLE 0 N/A 4603 0
RFS 5116 IDLE 1 6 4555 142
ARCH 4043 CLOSING 1 12 4043 139
ARCH 4039 CLOSING 1 11 4039 140
ARCH 4033 CLOSING 1 13 4033 141
ARCH 4041 CLOSING 1 11 4041 137
10 rows selected.
SYS@enmodg>select GROUP#,THREAD#,SEQUENCE#,STATUS from v$log;
GROUP# THREAD# SEQUENCE# STATUS
---------- ---------- ---------- ----------------
4 1 0 UNUSED
5 1 0 UNUSED
6 1 0 UNUSED
SYS@enmodg>select GROUP#,DBID,THREAD#,SEQUENCE# from v$standby_log;
GROUP# DBID THREAD# SEQUENCE#
---------- ---------------------------------------- ---------- ----------
11 UNASSIGNED 1 0
12 850702656 1 142
13 UNASSIGNED 1 0
14 UNASSIGNED 1 0
我来答
添加附件
收藏
分享
问题补充
7条回答
默认
最新
ARCH还是LGWR同步？
select process,client_process,thread#,sequence#,status from v$managed_standby;
查一下呢？
评论
有用 0SYS@enmodg>select process,client_process,thread#,sequence#,status from v$managed_standby;
PROCESS CLIENT_P THREAD# SEQUENCE# STATUS
--------- -------- ---------- ---------- ------------
ARCH ARCH 1 141 CLOSING
DGRD N/A 0 0 ALLOCATED
DGRD N/A 0 0 ALLOCATED
ARCH ARCH 1 140 CLOSING
ARCH ARCH 1 137 CLOSING
ARCH ARCH 1 139 CLOSING
RFS Archival 0 0 IDLE
RFS LGWR 1 142 IDLE
RFS UNKNOWN 0 0 IDLE
RFS UNKNOWN 0 0 IDLE
MRP0 N/A 1 142 APPLYING_LOG
11 rows selected.
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
墨值悬赏