How to Investigate a Slow or Hanging Database Performance Issue
(Doc ID 2351544.1)
Last updated on MAY 19, 2022
Applies to: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
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
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.
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
|Collecting Database Performance Diagnostics for a Performance Service Request|
|Database is Experiencing Slowness, Hanging or Unusual High Wait Events|
|Database is Experiencing Slowness due to a Specific SQL Statement|