Avoiding Upgrade Related Query Issues
(Doc ID 167086.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Oracle Database - Personal Edition - Version 8.1.7.4 and laterOracle 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
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Purpose
This article outlines a number of the steps for consideration prior to embarking on a database upgrade with the goal of early problem identification and quick resolution in the unlikely event of problems.
Scope and Application
Oracle Support Analysts, DBA's and Application Developers
Best Practices
Pro-Active Problem Avoidance and Diagnostic Collection
Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. For information on suggested preparations to avoid issues and in case diagnostics are required, see:
<Document 1477599.1> Best Practices Around Data Collection For Performance Issues
Useful Companion Articles:
<Document 601807.1> Oracle 11gR1 Upgrade Companion
<Document 466181.1> 10g Upgrade Companion
<Document 465787.1> Managing CBO Stats during an upgrade to 10g or 11g
<Document 1645862.1> Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results
<Document 1392633.1> Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
<Document 1320966.1> Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
Useful Webcast:
11G Upgrade Best Practices :
This recorded seminar provides an overview of tips and best practices for upgrading your database to 11G. It starts with general Challenges and Support Best Practices, but moves on to performance specifics such as AWR and STATSPACK, SQL Plan Management, and Real Application Testing.
This webcast can be found here: 11G Upgrade Best Practices (Requires Internet Explorer)
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 |
Scope and Application |
Best Practices |
Pro-Active Problem Avoidance and Diagnostic Collection |
Useful Companion Articles: |
Useful Webcast: |
Troubleshooting Steps |
General Steps |
Testing |
System |
CBO Statistics |
Execution Information |
Individual Statements - Manual Steps |
Plan Stability |
Resource Usage |
Check which optimizer is being used. |
References |