How to Investigate a Slow or Hanging Database Performance Issue

(Doc ID 2351544.1)

Last updated on FEBRUARY 09, 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



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 hundreds of Community platforms