My Oracle Support Banner

Gathering Information for RDBMS Performance Tuning issue (Doc ID 339834.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2.0.1 [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

Performance problems are generally hard to resolve, but it becomes even more difficult if we do not know where to look for the right information.

Collecting the right diagnostic information is most important first step in solving a problem.

Different kind of performance issues warrants collection of different information. This document intends to cover some of the most commonly encountered performance problems by Oracle Support, and advices what information should be collected for each of these issues. It can be used as a checklist to simply gather information and files usually requested by Oracle Support in order to solve a RDBMS performance issues, or it can be utilized as a process which walks the reader through common steps of the troubleshooting process for RDBMS related performance issues.

While following this process, you may solve your performance issue. If not, you will have gathered the standard information and files required to pursue its resolution. The next step is analyzing this information. We do NOT cover this in this document.

Scope

This document will be useful to Support Engineers and Database Administrators who are trying to solve performance problems.

Details

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
Purpose
Scope
Details
 What is Performance?
 Problem Definition
 Why did the performance problem occur?
 Collecting Information for the Performance Problem
 Common Set of Questions for all Kind of tuning issues:
 1) Some query is slow:
 2) Application is slow:
 3) Database is slow : This is the most common scenario
 4) Database is hung:
 5) Query Giving Wrong results:
References

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