My Oracle Support Banner

Troubleshooting Query Performance Degradation - Recommended Actions (Doc ID 742112.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.

Purpose

Introduction

This Note provides an action plan for gathering Query Performance Degradation diagnostics and suggests ideas for quickly recovering the situation.

Background

There are a number of reasons why the performance of a query or queries may degrade. The most likely cause is that the query being executed is now using a different access path than previously. Common causes are:

NOTE: This article does not specifically cover cases where software has changed or has been upgraded. For these cases, See: 

<Document 745216.1> Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions
<Document 160089.1> Troubleshooting Server Upgrade Resulting in Slow Query Performance

If you have changed to different hardware and performance has degraded, the following article suggests a number of useful suggestions:

<Document 604256.1> Why is a Particular Query Slower on One Machine (or Instance) than Another?

For more general Query Performance Issues see:

<Document 398838.1> FAQ: Query Tuning Frequently Asked Questions

For Database wide performance Issues see:

<Document 1377446.1> Troubleshooting Performance Issues

Troubleshooting 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!


In this Document
Purpose
Troubleshooting Steps
References

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