* Troubleshooting Performance Issues (Doc ID 1377446.1)

Last updated on OCTOBER 17, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

This article provides a central point for Performance Troubleshooting advice.

You can access categorised Troubleshooting information via the following:

<Document 1542678.2> Troubleshooting Assistant: SQL Performance Issues

This articles supersedes :

<Document 106285.1> TROUBLESHOOTING GUIDE: Common Performance Tuning Issues (ARCHIVED)

Best Practices

Pro-Active Problem Avoidance and Diagnostic Collection

Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. For information on suggested preparations to avoid issues and in case diagnostics are required, see:

<Document 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance Issues
<Document 1477599.1> Best Practices Around Data Collection For Performance Issues

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