5.412 DBA_HIST_INTERCONNECT_PINGS
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
|