DBA AWR Interconnect Traffic – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Displays information about the usage of an interconnect device by instance in a RAC configuration.
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.
Report Parameters
Date From, Date To, Name, Diagnostic Pack enabled, Container Data
Oracle EBS Tables Used
dba_hist_snapshot, dba_hist_ic_client_stats
Report Categories
Related Reports
DBA SGA+PGA Memory Configuration, DBA AWR System Metrics Summary, DBA AWR Latch by Time, DBA AWR Settings, DBA AWR System Time Percentages, DBA AWR PGA History, DBA AWR Blocking Session Summary, DBA AWR Wait Class by Time, DBA AWR SQL Performance Summary
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA AWR Interconnect Traffic 24-Aug-2024 132126.xlsx |
| Blitz Report™ XML Import | DBA_AWR_Interconnect_Traffic.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-awr-interconnect-traffic/ |
Executive Summary
The DBA AWR Interconnect Traffic report is essential for managing Oracle Real Application Clusters (RAC). In a RAC environment, instances communicate over a private high-speed network (the Interconnect) to share data blocks and manage locks. If this network becomes congested, the entire cluster’s performance suffers. This report monitors the traffic across this critical link.
Business Challenge
- RAC Scalability: “Why does adding a node make the application slower?” (Often due to excessive interconnect traffic).
- Application Design: Identifying “Chatty” applications that constantly move data blocks between instances (Global Cache Transfer).
- Network Sizing: Verifying if the private network bandwidth is sufficient for the workload.
Solution
This report displays traffic statistics for the interconnect.
Key Features:
- Traffic Types: Breaks down traffic by category:
ipq: Parallel Query (often high bandwidth).dlm: Distributed Lock Manager (locking coordination).cache: Global Cache (block transfers).
- Instance View: Shows traffic per instance.
Architecture
The report queries DBA_HIST_IC_CLIENT_STATS.
Key Tables:
DBA_HIST_IC_CLIENT_STATS: Interconnect statistics history.
Impact
- Cluster Stability: Prevents node evictions caused by interconnect saturation.
- Performance Tuning: Highlights the need for “Application Partitioning” (keeping related data on the same node) to reduce traffic.
- Infrastructure Validation: Confirms that the network hardware is performing as expected.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics