E-ORA: PS Query Performance Issues after Oracle Upgrade to 12.1.0.2 (Doc ID 2163277.1)

Last updated on JULY 20, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

On : 8.53 version, Database-Oracle

ACTUAL BEHAVIOR
---------------
After upgrading Oracle database from 11.2.0.4 to 12.1.0.2 and PeopleTools from 8.53.10 to 8.53.24, customer is experiencing query timeout and failure issues. The same queries are running in just a few seconds in the pre-upgraded environment.


EXPECTED BEHAVIOR
-----------------------

PS Query should be performing within seconds


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade Oracle RDBMS to 12.1.0.2 from 11.2.0.4
2. Run the PS Query


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with moving the environment to Oracle 12.1.0.2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms