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 later
Oracle 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 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)