My Oracle Support Banner

Avoiding Upgrade Related Query Issues (Doc ID 167086.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Standard Edition - Version 8.1.7.4 and later
Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Oracle Database - Personal Edition - Version 8.1.7.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - 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 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance Issues
<Document 1477599.1> Best Practices Around Data Collection For Performance Issues

Useful Companion Articles:

<Document 785351.1> Oracle 11gR2 Upgrade Companion
<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

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