My Oracle Support Banner

Slower Application Performance after Database Upgraded from 10g to 12cR2 (Doc ID 2749146.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Application team reported slowness in the production database after it has been upgraded/migrated from 10.2.0.3 to 21.2.0.1.
All the Jobs are taking more time to complete as compared to older version (11g) of the database.

 The application job used to take 2 minutes under Solaris 10 and Oracle 10g but it now takes about 20 minutes to create same data files from the application where the data is written and later on the file is zipped.

 AWR reports indicated that all the SQLs are running with same timing or faster in 12.2.0.1 compared to 10.2.0.3.

Changes

1. OS was upgraded from Solaris 10 to Solaris 11.

2. Veritas File System (VxFS) is used for the database files and the related software has been upgraded to 7.1.

3. Database version was changed from 10.2.0.3 to 12.2.0.1.

4. Some of the slower application jobs use Pro*C application. There was no change in the application code.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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