E-ORA:- PSCBO stats and performance issue (Doc ID 2045269.1)

Last updated on JANUARY 24, 2017

Applies to:

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

Goal

PT version - 8.53.17, App version - HCM 9.0 Global Payroll, RDBMS version - Oracle 11.2.0.3.0
“A PSCBO job has been configured to run daily in our production environment and  facing performance issues on one of the tables GP_RSLT_ACUM which contains about 528 million rows. The issue is that calc process gets stuck in a sql query involving the particular table and  have to kill the session and run PSCBO stats manually on the table to resolve that.
 
Our daily PSCBO job picks up this table once every 4-5 weeks. However, we face this issue about 3 weeks after this table was last analyzed. Do you have any suggestions to avoid this performance issue going forward?”
 

Solution

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