My Oracle Support Banner

How to Investigate a Slow or Hanging Database Performance Issue (Doc ID 2351544.1)

Last updated on JANUARY 21, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

This article outlines the basic steps to take when faced with a Slow Database Performance Problem. Database performance issues have a wide variety of causes but typically the primary symptoms are that the database is slow or in extreme cases 'hung'.

Collecting Database Performance Diagnostics for a Performance Service Request

Service Request Data Collection (SRDC) documents have been specially designed to provide the reader with the necessary instructions to collect information for common Database Performance issues.

<Document 2315692.1> SRDC - How to Collect Standard Information for a Database Performance Problem Using TFA Collector (Recommended) or Manual Steps

 

Solution

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
Goal
 Collecting Database Performance Diagnostics for a Performance Service Request
Solution
 Database is Experiencing Slowness, Hanging or Unusual High Wait Events
 Database is Experiencing Slowness due to a Specific SQL Statement
 Community Discussions
References

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