DBA_HIST_SYSMETRIC_SUMMARY中的Network Traffic Volume Per Sec 指标是指什么?

最新推荐文章于 2021-04-13 15:36:00 发布

翻译最新推荐文章于 2021-04-13 15:36:00 发布 · 1.4k 阅读

文章标签：

#Network #Traffic #Volume #Per #Sec

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文解释了Oracle数据库中Network Traffic Volume Per Sec指标的意义。该指标反映了每秒公共网络流量的大小，单位为字节，并汇总了所有客户端及数据库链接的网络流量。通过查询DBA_HIST_SYSMETRIC_SUMMARY表可以获取此指标的具体数值。

翻译自:

What Is Metric "Network Traffic Volume Per Sec" In DBA_HIST_SYSMETRIC_SUMMARY ? (Doc ID 1548632.1)

适用于:
Oracle Net Services - Version 10.2.0.4 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

目标:

What is the meaning of Network Traffic Volume Per Sec metric. It is populated in DBA_HIST_SYSMETRIC_SUMMARY. But not included in any external or internal MOS document

解决方法

The metric gives info about public network traffic per second

In Oracle 10g, there is a table called DBA_HIST_SYSMETRIC_SUMMARY which stores information about the database activities. One of the metric is called NETWORK TRAFFIC VOLUME Per/Sec (metric_id=2058).

The value is in bytes per second. A typical query may be something like:

select minval, maxval, average
from dba_hist_sysmetric_summary
where metric_id=2058

The value represents the combined network traffic from all clients and database links.

It's use for customers will vary. One use would be to gauge the capacity of the NIC on the server. However, there are other tools (such as ipref) that can do this as well.