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 and later
Information in this document applies to any platform.


Application team reported slowness in the production database after it has been upgraded/migrated from to
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 compared to


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 to

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



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

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