My Oracle Support Banner

RDBPROD: How to Troubleshoot Performance Problems Involving Access to an Rdb Database via a DBlink (Doc ID 867679.1)

Last updated on APRIL 16, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Rdb Server on OpenVMS - Version 7.2 and later
Oracle SQL/Services for Rdb on OpenVMS - Version 7.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This guide is intended to explain how to investigate a query that is running slower than expected when that query involves access to an Rdb database via a DBlink.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Versions
 Trace Files
 Is the Problem in Rdb?
 Not Rdb?
 Statistics
 OCI Services Version
 Statistics in the Trace
 TableScan Cost
 Collecting Better Statistics
 Outer Join
 Still Slow
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.