Oracle 视图 DBA_HIST_INTERCONNECT_PINGS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图名称：DBA_HIST_INTERCONNECT_PINGS
说明：该视图显示心跳检测（ping）从网络拓扑元素发送到Oracle RAC之间，执行情况的历史信息和结果。
用途：该视图可以用来监控服务器与服务器之间的网络连接情况及状态，以确保服务器间的网络拓扑可行的正常运行，在出现网络异常的情况下，可以根据视图中反馈的历史 ping 信息对其进行必要的处理，保证网络的正常运行。
使用方法：
1.查看ping的历史结果：
SELECT * FROM DBA_HIST_INTERCONNECT_PINGS;
2.根据主机名查询ping的历史结果：
SELECT * FROM DBA_HIST_INTERCONNECT_PINGS WHERE HOST = ‘hostname’;
3.根据时间查询ping的历史结果：
SELECT * FROM DBA_HIST_INTERCONNECT_PINGS WHERE SNAP_TIME > start_time
AND SNAP_TIME
官方英文解释
DBA_HIST_INTERCONNECT_PINGS displays information about measured latency of interconnect messages (round-trip) from instance to instance.
In Oracle Database 11g and later releases, the PING process assesses the latencies associated with communications for each pair of instances.
Every few seconds, the process in one instance (INSTANCE_NUMBER value) sends two messages to each instance (TARGET_INSTANCE value). One message has a size of 500 bytes and the other has a size of 8 KB. The message is received by the PING process on the target instance and is immediately acknowledged. The time for the round-trip is measured and collected.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
|
Target instance number |
|
|
|
Number of pings of size 500 bytes from |
|
|
|
|
Sum of round-trip times for messages of size 500 bytes from |
|
|
|
|
Sum of squares (divided by 1000) of round-trip times for messages of size 500 bytes from |
|
|
|
|
Number of pings of size 8 KB from |
|
|
|
|
Sum of round-trip times for messages of size 8 KB from |
|
|
|
|
Sum of squares (divided by 1000) of round-trip times for messages of size 8 KB from |
|
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
