Home Discussions Questions & Answers Performance Impact of RAC Interconnect Traffic

Performance Impact of RAC Interconnect Traffic

Avatar photoCustomer March 14, 2020 at 4:47 am

We run Oracle EBS on a Real Application Clusters (RAC) environment and suspect high inter-instance traffic might be slowing us down. How can I use Blitz Report to analyze the usage of the interconnect device by instance?

Viewing 4 reply threads
  • Author
    Replies
    • Support March 16, 2020 at 6:17 am  

      You should use the DBA AWR Interconnect Traffic report. This report displays information about interconnect usage by instance in a RAC configuration.

    • Avatar photoCustomer March 16, 2020 at 1:33 pm  

      What are the key categories of traffic measured in this report that I should look for?

    • Support March 17, 2020 at 2:49 am  

      The key categories displayed are `ipq` (Parallel query communications), `dlm` (Database lock management), and `cache` (Global cache communications). Other values are typically internal to Oracle and not expected to have high usage.

    • Avatar photoCustomer March 17, 2020 at 9:43 pm  

      If cache traffic is high, what does that usually indicate?

    • Support March 18, 2020 at 6:20 am  

      High `cache` traffic indicates frequent global cache communications, often implying that buffer blocks are being transferred frequently between instances. This may point toward poor data locality or insufficient buffer cache sizing.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: