Oracle 视图 DBA_HIST_CR_BLOCK_SERVER 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图是指一个可以以表格形式显示的查询结果集，它通常也被称为虚拟表，无需重新创建表或者定义数据，用户可以通过视图对同一个或多个表中的数据进行查询。

The DBA_HIST_CR_BLOCK_SERVER视图，主要查看被阻塞服务器的历史信息，可以用以下查询来使用它：

SELECT timestamp,server_name,blocks,fixed,failures
FROM dba_hist_cr_block_server;

这会显示时间戳，服务器名称，被阻塞的行数，已经解决的阻塞和失败的阻塞的数量。

官方英文解释

DBA_HIST_CR_BLOCK_SERVER displays historical statistics on the Global Cache Service processes (LMS) used in cache fusion.

This view contains snapshots of V$CR_BLOCK_SERVER.

Number of current blocks served due to remote CR block requests

CR_REQUESTS + CURRENT_REQUESTS = global cache CR blocks served (from V$SYSSTAT).

Number of CR requests for undo segment header blocks

DATA_REQUESTS + UNDO_REQUESTS + TX_REQUESTS = total number of requests handled by the LMS processes

Number of requests for which no changes were rolled out of the block returned to the requesting instance

Number of requests for which changes were rolled out of the block returned to the requesting instance, and only the requesting transaction can use the resulting CR block

Number of requests for which changes were rolled out of the block returned to the requesting instance. Only zero-XID transactions can use the block.

Number of requests for which the requesting instance had to read the requested block from disk

Number of requests that failed; the requesting transaction must reissue the request

Number of times an instance receiving a request has down-converted an X lock on a block because it was not modifying the block

Number of times the light-work rule was evoked. This rule prevents the LMS processes from going to disk while responding to CR requests for data, undo, or undo segment header blocks. This rule can prevent the LMS process from completing its response to the CR request.

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_HIST_CR_BLOCK_SERVER 官方解释，作用，如何使用详细说明