My Oracle Support Banner

E-PC/AE/DB: Large Number of Loop on SQLExec or SQL Object PeopleCode Functions Cause Accumulated Performance Slow Down (Doc ID 2008270.1)

Last updated on OCTOBER 14, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : 8.54 version, Application Engine

Case #1. In HCM upgrade, when running the Run the PTIADATACONV program, step UPG_PY90 run for a long time for days, not able to complete.

Case #2. After PT upgrade from PT 8.51 to PT 8.54, an AE program that using a loop to call SQLExec() or using SQL object to execute SQL repeatedly, it run much slow then before PT upgrade.  

AET timing reports

in 8.54

E x e c u t e 

PEOPLECODE Builtin/Method Count Time
------------------------------------------------------- ------- --------
Number(Decimal)(Type 0) BuiltIns 11 0.000
String(Type 1) BuiltIns 88 0.000
Boolean(Type 5) BuiltIns 88 0.250
Integer(Type 17) BuiltIns 22 0.220
File(Type 524289) Methods 44 0.010
File(Type 524289) BuiltIns 11 0.060
SQL(Type 524290) Methods 290750 147.170
SQL(Type 524290) BuiltIns 89065 3178.410 <<<<<<<<<<<<<<< extra large time spent on SQL object function calls
Record(Type 524291) Methods 356210 3.350
Record(Type 524291) BuiltIns 23 0.000
Rowset(Type 524295) Methods 557894 3.470
Rowset(Type 524295) BuiltIns 178107 3.560
Row(Type 524296) Methods 445263 0.860

  

in 8.51

E x e c u t e 

PEOPLECODE Builtin/Method Count Time
------------------------------------------------------- ------- --------
Number(Decimal)(Type 0) BuiltIns 11 0.0
String(Type 1) BuiltIns 88 0.0
Boolean(Type 5) BuiltIns 88 0.1
Integer(Type 17) BuiltIns 22 2.1
File(Type 524289) Methods 89118 9.3
File(Type 524289) BuiltIns 11 0.0
SQL(Type 524290) Methods 290856 65.8
SQL(Type 524290) BuiltIns 89086 471.1 <<<<<<<<<<< small time spent on SQL object func calls
Record(Type 524291) Methods 356324 2.5
Record(Type 524291) BuiltIns 23 0.0
Rowset(Type 524295) Methods 647178 4.5
Rowset(Type 524295) BuiltIns 23 0.0
Row(Type 524296) Methods 445409 0.8

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.