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 |
---|---|---|
|
|
Database client name initiating the network I/O (for example, RMAN or PL/SQL) |
|
|
Number of read operations issued |
|
|
Number of write operations issued |
|
|
Total number of kilobytes read |
|
|
Total number of kilobytes written |
|
|
Total read wait time (in milliseconds) |
|
|
Total write wait time (in milliseconds) |
|
|
The ID of the container to which the data pertains. Possible values include:
|