Troubleshooting a Server Upgrade Resulting in Slow Query Performance
(Doc ID 160089.1)
Last updated on JUNE 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 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.
Checked for Currency 9th July 2012
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:
which suggests information that should be collected prior to an upgrade and strategies to avoid query related upgrade problems (as far as possible).
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 Other Issues|