My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2022

Applies to:

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



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.


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
Troubleshooting Steps
 Key Actions
 Troubleshooting Other Issues

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