Database Reference
In-Depth Information
Jumbo frame support is designed to enhance Ethernet networking throughput and significantly reduce the CPU
utilization of large file transfers such as large multimedia files or large data files by enabling more efficient, larger
payloads per packet. Sending large frame sizes avoids reassembly and fragmentation costs for data blocks, reduces
the overhead on CPU, and improves throughput. Larger frame sizes also reduces chances for lost blocks encountered
during transfers on busy interconnects. By using jumbo frames, the transfer frame sizes for Ethernet could be
increased to 9,000 bytes.
Verifying the Interconnect
Tuning the cluster interconnect should begin with verifying the hardware configuration. This basic check should
ensure that the database is using the correct IP addresses or NICs for the interconnect.
Check 1
The following query provides a list of IP addresses registered with the Oracle database kernel:
Script:MVRACPDnTap_verifyic.sql
SELECT addr,
indx,
inst_id,
pub_ksxpia,
picked_ksxpia,
name_ksxpia,
ip_ksxpia
FROM x$ksxpia;
Impl
ADDR Indx Public Type Name IP Address
---------------- ------ ---------- ---------- ---------- ---------------
00002ABF8F3EA550 0 N OCR bond2 172.30.0.16
00002ABF8F3EA550 1 Y OCR bond0 10.32.5.7
SELECT inst_id,
name,
ip_address,
is_public
FROM gv$cluster_interconnects
ORDER BY inst_id;
Instance Name IP_ADDRESS IS_ SOURCE
-------- ---------- ---------------- --- -------------------------------
1 bond2 172.30.0.16 NO Oracle Cluster Repository
2 bond2 172.30.0.17 NO Oracle Cluster Repository
3 bond2 172.30.0.10 NO Oracle Cluster Repository
4 bond2 172.30.0.11 NO Oracle Cluster Repository
5 bond2 172.30.0.12 NO Oracle Cluster Repository
6 bond2 172.30.0.13 NO Oracle Cluster Repository
Search WWH ::
Custom Search