My Oracle Support Banner

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

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Standard Edition - Version and later
Oracle Database - Personal Edition - Version and later
Oracle Database - Enterprise Edition - Version 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.

<Document 2315692.1> SRDC - How to Collect Standard Information for a Database Performance Problem Using TFA Collector (Recommended) or Manual 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!

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