29 积分	0 好友	5 主题

发消息

如何得到oracle心跳网络流量趋势图

1^#

发表于 2012-1-19 22:58:12 | 查看: 8247| 回复: 5

在dbconsole 能看到趋势图，如何通过数据字典得到这个趋势图呢？

a.PNG (33.19 KB, 下载次数: 430)

分享0

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2012-1-19 22:59:52

key word :  AWR db_hist table & interconnect bandwidth

ODM Data:

dba_hist_ic_client_stats

DBA_HIST_IC_CLIENT_STATS displays information about the usage of an interconnect device by the instance. The information is divided into several areas of the Oracle Database, each identified by the NAME value.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
NAME VARCHAR2(9) NOT NULL Identifies the area of the Oracle Database:
ipq - Parallel query communications
dlm - Database lock management
cache - Global cache communications
All other values are internal to Oracle and are not expected to have high usage.

BYTES_SENT NUMBER      Number of bytes sent by the instance since instance startup for the software area identified by NAME. This information is aggregated across all devices used by the instance.
BYTES_RECEIVED NUMBER      Number of bytes received by the instance since instance startup for the software area identified by NAME. This information is aggregated across all devices used by the instance.

回复只看该作者道具举报

Liu Maclean(刘相兵

3^#

发表于 2012-1-19 23:10:35

another view dba_hist_ic_device_stats in 11gR2

DBA_HIST_IC_DEVICE_STATS displays operating system information about the usage of interconnect devices by the machine. This usage contains Oracle usage but is not limited to it. The quality of the information depends on the operating system.

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select * from dba_hist_ic_device_stats where rownum < 7;
SNAP_ID DBID INSTANCE_NUMBER IF_NAME IP_ADDR NET_MASK FLAGS MTU BYTES_RECEIVED PACKETS_RECEIVED RECEIVE_ERRORS RECEIVE_DROPPED RECEIVE_BUF_OR RECEIVE_FRAME_ERR BYTES_SENT PACKETS_SENT SEND_ERRORS SENDS_DROPPED SEND_BUF_OR SEND_CARRIER_LOST
---------- ---------- --------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------------------------- ---------- -------------- ---------------- -------------- --------------- -------------- ----------------- ---------- ------------ ----------- ------------- ----------- -----------------
377 881465081 2 eth0 192.168.1.163 255.255.255.0 UP|RUNNING 1500 202003348 653647 0 0 0 0 216216460 524718 0 0 0 0
377 881465081 2 eth0:1 192.168.1.164 255.255.255.0 UP|RUNNING 1500 0 0 0 0 0 0 0 0 0 0 0 0
377 881465081 2 eth0:2 192.168.1.162 255.255.255.0 UP|RUNNING 1500 0 0 0 0 0 0 0 0 0 0 0 0
377 881465081 2 eth0:3 192.168.1.200 255.255.255.0 UP|RUNNING 1500 0 0 0 0 0 0 0 0 0 0 0 0
377 881465081 2 eth1 172.168.1.19 255.255.255.0 UP|RUNNING 1500 8261820164 16950957 0 0 0 0 1478740781 21731006 0 0 0 0
377 881465081 2 eth1:1 169.254.145.211 255.255.0.0 UP|RUNNING 1500 0 0 0 0 1398030667 4 6 140257986791 158721248 0 0 0
6 rows selected

复制代码

回复只看该作者道具举报

overmars

4^#

发表于 2012-1-19 23:38:44

你这个结果，是使用2单独个网卡作为心跳，请问，这2个网卡是不是分别连接在2个交换机上面？

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2012-1-19 23:42:24

对于 Oracle 而言它只感知到网络接口 network interface的信息： eth0 eth1:1 这种；对于实际的物理拓扑信息 oracle无从得知。

回复只看该作者道具举报

raddison

6^#

发表于 2017-4-27 18:25:53

Liu Maclean(刘相兵发表于 2012-1-19 23:10
another view dba_hist_ic_device_stats in 11gR2

DBA_HIST_IC_DEVICE_STATS displays operating system ...

刘大，请问下，DBA_HIST_IC_DEVICE_STATS 或者DBA_HIST_IC_CLIENT_STATS，为什么只有历史表，当前的信息就没有一个对应的视图可以查看实时的吗？

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册