侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

V$LOGSTDBY_PROCESS动态性能视图

与晚风述往事
2021-11-25 / 0 评论 / 0 点赞 / 152 阅读 / 1,731 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-11-25,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

V$LOGSTDBY_PROCESS视图提供了查询在Data Guard日志应用过程发生的情况的接口。
此视图通常用于诊断在归档日志逻辑应用到备用数据库期间的性能问题。

限制

此视图仅适用于逻辑备用数据库。

视图详情

下面列表信息来源于Oracle 11G官方文档,本人仅做简单翻译,方便下次查询;暂时没有逻辑备份的Data Guard环境,里面的多数内容暂无法验证。

字段名 字段类型 描述 备注
SID NUMBER Session id of the associated session. This matches the SID column of the corresponding row in the V$SESSION view. 会话的SID 与V$SESSION视图的SID列对应。
SERIAL# NUMBER Serial number of the associated session. Together, (SID,SERIAL#) uniquely identify the session in the current database instance. 会话的序列号 SID和SERIAL#列加起来确定当前数据库实例的会话,单独一列不能确定会话唯一。
LOGSTDBY_ID NUMBER Parallel query slave ID 并行查询的子进程ID
SPID VARCHAR2(12) This corresponds to the SPID value of the row corresponding to this process in the V$PROCESS view 服务器中的进程号 与V$PROCESS视图的SPID列对应。
TYPE VARCHAR2(30) Role that the process plays in the context of SQL Apply:
COORDINATOR
APPLIER
ANALYZER
READER
PREPARER
BUILDER
STATUS_CODE NUMBER Operation code identifying the current action of the process:
16111 - SQL Apply process is initializing
16112 - SQL Apply process is cleaning up as apply and mining processes are stopping based on a user command
16116 - SQL Apply process is idle
16117 - SQL Apply process is busy and is not waiting on any interesting event
16110 - APPLIER process has invoked a user-provided stored procedure in order to inspect a DDL statement prior to it being processed
16113 - APPLIER process is applying DML changes to some user object or to a sequence
16114 - APPLIER process is applying a DDL change
16115 - COORDINATOR process is loading the LogMiner dictionary from the redo stream
16243 - BUILDER process is paging out memory to free up space in lcr cache
16240 - READER process idle waiting for additional logfile to be available
16241 - READER process is idle waiting for the logfile to fill the log sequence gap
16242 - READER process is processing a logfile
STATUS VARCHAR2(256) Description of the current action of the process 当前活动的状态
HIGH_SCN NUMBER Identifies the highest redo record/LCR processed by this process 此过程处理的最大重做记录/LCR
0

评论区