My Oracle Support Banner

Troubleshooting a Server Upgrade Resulting in Slow Query Performance (Doc ID 160089.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
Checked for Currency 9th July 2012

Purpose

PURPOSE

This article is designed as a checklist/start point for investigating issues where the database software has been upgraded or the database has been moved to a different system and this has resulted in a drop in query performance.

SCOPE and APPLICATION

The article only covers query performance as opposed to database performance.
Prior to upgrading it is recommended to record relevant information regarding the system and the performance of key queries to assist fix problems rapidly in the event of problems.
Please refer to:

<Document 167086.1> Tips for avoiding upgrade related query problems


which suggests information that should be collected prior to an upgrade and strategies to avoid query related upgrade problems (as far as possible).

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
 Key Actions
 ADDITIONAL ACTIONS:
 Troubleshooting Other Issues
References

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