EPC 9.2 : Performance Issue With Calculate Percent Complete (PC_PERCENT) Process At Steps PC_PERCENT.41000000.SELECT, and PC_PERCENT.AMOUNT.SELECT2
(Doc ID 2918851.1)
Last updated on JANUARY 07, 2023
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Performance issue with PC_PERCENT Process.
Sample Timings Summary:
C o m p i l e E x e c u t e F e t c h Total
SQL Statement Count Time Count Time Count Time Time
-------------------------------------------------------------------------------------------------------------------------------------------------
PC_PERCENT.41000000.SELECT 163828 24.770 163828 7117.510 163828 0.000 7142.280
PC_PERCENT.AMOUNT.SELECT2 455639 34.260 455639 2069.410 455639 0.000 2103.670
---
Total run time: 20120.730
Total time in application SQL: 15685.310 Percent time in application SQL : 78.0%
Total time in PeopleCode: 182.090 Percent time in PeopleCode : 0.9%
Total time in cache: 1.810 Number of calls to cache : 164053
---
Replication Steps:
- Run the process Project Costing > Utilities > Calculate Percent Complete with 17 Business units in the run control and it took 5 hours. When the process is run with 33 business units it took 9 hours.
Cause
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
Symptoms |
Cause |
Solution |
References |