PSA_ACCTGGL.SEL_PC PERFORMANCE DUE TO LACK OF UPDATESTATS AFTER PSA_ACCTG_TA1
(Doc ID 2132825.1)
Last updated on MAY 16, 2019
Applies to:PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Performance issue with PSA_ACCTGGL due to lack of UpdateStats after truncate/inserting data into PSA_ACCTG_TA1.
Following steps in Sel_PC section Insert or Delete rows from %Table(PSA_ACCTG_TA1).
Some steps also are doing a NOT EXISTS (select ‘x’ from %Table(PSA_ACCTG_TA1)….)
From above message log, Revenue Step inserts zero rows and StatsTA1 step updates stats so that %Table(PSA_ACCTG_TA1) contains zero rows. Cost Step is inserting 221331 rows into %Table(PSA_ACCTG_TA1), for which there is No Update Stats resulting in poor performance on step SharingB.
Also creating new index on PSA_ACCTG_TA1(PROCESS_INSTANCE, RESOURCE_ID) helps improve the performance along with adding UpdateStats mentioned above.
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