29 积分	0 好友	5 主题

发消息

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

1^#

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

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

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

分享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