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

本站中文解释

Oracle视图 V$IOSTAT_NETWORK 是网络I/O统计的动态性能视图,用于显示实例的网络I/O统计信息。以下是它的列:

COLUMN_NAME DATA_TYPE ____________________________________________
BYTES_SENT NUMBER
BYTES_RECEIVED NUMBER
NETWORK_TIME NUMBER
BYTES_PER_NETWORK_TIME NUMBER

使用方法: 在sql*plus命令行下可以使用SELECT语句查询V$IOSTAT_NETWORK视图,例如:

sql> SELECT sum(bytes_sent) AS bytes_sent,
sum(bytes_received) AS bytes_received,
sum(network_time) AS network_time,
sum(bytes_per_network_time) AS bytes_per_network_time
FROM v$iostat_network;

官方英文解释

V$IOSTAT_NETWORK displays information about network I/O statistics that were caused by accessing files on a remote database instance.

Column Datatype Description

CLIENT

VARCHAR2(32)

Database client name initiating the network I/O (for example, RMAN or PL/SQL)

READS#

NUMBER

Number of read operations issued

WRITES#

NUMBER

Number of write operations issued

KBYTES_READ

NUMBER

Total number of kilobytes read

KBYTES_WRITTEN

NUMBER

Total number of kilobytes written

READ_LATENCY

NUMBER

Total read wait time (in milliseconds)

WRITE_LATENCY

NUMBER

Total write wait time (in milliseconds)

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$IOSTAT_NETWORK 官方解释,作用,如何使用详细说明