TROUBLESHOOTING: Tuning Slow Running Queries
(Doc ID 179668.1)
Last updated on SEPTEMBER 20, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
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 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.
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
|Performance Service Request Diagnostic Collection (SRDC) documents|