How to Investigate Slow or Hanging Database Performance Issues
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle Database - Standard Edition - Version 188.8.131.52 and later
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Personal Edition - Version 220.127.116.11 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 Performance Diagnostics with 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 2065320.1> SRDC - How to Collect Standard Information for a Database Performance Problem (without Diagnostic Pack License)
<Document 2156456.1> SRDC - How to Collect Standard Information for a Database Performance Problem for 11g or Greater on Unix/Linux (with Diagnostic Pack License)
There is a full list of the documents in the following:
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