Oracle 视图 V$GCR_LOG 官方解释，作用，如何使用详细说明-云搜网

_SEND_BANDWIDTH

V$GCR_LOG_SEND_BANDWIDTH 是一个Oracle数据库视图，是Data Guard 中的一部分，主要用于统计每小时发送Redo Log流量，有助于DBA了解Redo Log在Data Guard集群中发送消息的情况。它由以下几列组成：

SEND_TIME：Redo Log发送的时间
REDO_BYTES_PER_HOUR：每小时发送的Redo Log字节
REDO_BYTES_PER_MINUTE：每分钟发送的 Redo Log字节。

V$GCR_LOG_SEND_BANDWIDTH 视图可以通过使用SELECT语句来查询，示例如下：

SELECT * FROM V$GCR_LOG_SEND_BANDWIDTH
WHERE SEND_TIME > SYSDATE – INTERVAL ‘1’ HOUR
ORDER BY SEND_TIME DESC;

这条SELECT语句将返回Redo Log过去一小时内每小时、每分钟发送的字节数目。

V$GCR_LOG provides information on the last 30 significant events that have occurred in GCR in the recent past.

Column	Datatype	Description
`INST_ID`	`NUMBER`	Instance identier
`ITERATION`	`NUMBER`	GCR internal iteration count
`TIME`	`TIMESTAMP(6)`	Timestamp of record
`TYPE`	`VARCHAR2(14)`	Type of record: `METRIC` `METRIC ENABLE` `METRIC DISABLE` `GLOBAL METRIC` `ACTION RAN` `RESET RAN`
`DESCRIPTION`	`VARCHAR2(40)`	Description of function
`RESULT`	`VARCHAR2(7)`	Result: `OK` `FAIL`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `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. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data.

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