My Oracle Support Banner

TROUBLESHOOTING: Tuning Slow Running Queries (Doc ID 179668.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 08-Aug-2013***

Purpose

This article explains and provides examples of methods that can be used to attempt to duplicate the explain plan of a query.

You can access various Performance related Troubleshooting information via the following:

<Document 1543445.2> Troubleshooting Assistant: Troubleshooting Performance Issues
<Document 1542678.2> Troubleshooting Assistant: SQL Performance Issues

<Document 1528847.1> Troubleshooting: Avoiding and Resolving Database Performance Related Issues After Upgrade
<Document 60.1> Troubleshooting Assistant: Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files

 

Performance Service Request Diagnostic Collection (SRDC) documents

Service Request Data Collection (SRDC) documents have been specially designed to provide the reader with the necessary instructions to provide a step by step guide to collecting information for a various common Database Performance Issues.

<Document 1938786.1> List of Available Database Performance Related SRDC Documents

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
 Performance Service Request Diagnostic Collection (SRDC) documents
Troubleshooting Steps
References

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