E-ORA:- PSCBO stats and performance issue
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.
PT version - 8.53.17, App version - HCM 9.0 Global Payroll, RDBMS version - Oracle 184.108.40.206.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?”
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