Troubleshooting Distributed Query Performance Issues
(Doc ID 1921358.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle Database - Personal Edition - Version 10.1.0.2 and later
Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
Purpose
This document outlines how to approach issues with queries that involve remote objects.
For earlier version there is a legacy version of this document here:
<Document 33838.1> Determining the execution plan for a distributed query (9i and below)
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 |
| How Oracle Processes Distributed Queries |
| Troubleshooting Distributed Queries |
| How To Determine The SQL Statement(s) Sent To The Remote Database |
| Distributed Query Examples |
| Example 1 - Select using 2 remote tables and 1 local table: |
| Example 2 - Select using 1 remote view and 1 local table. |
| Example 3 - All remote tables. |
| References |