My Oracle Support Banner

E-AE: How to Interpret Data from the Application Engine SQL Timing Trace (TraceAE=16384) (Doc ID 1263577.1)

Last updated on AUGUST 11, 2022

Applies to:

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

Goal

When performing an upgrade from FSCM 8.8SP1 to 9.1 and in the process of tuning the conversion process, the using the new sql timings trace (TRACEAE=16384) for the conversion process, has populated the timing info to table PS_AE_TIMINGS_LG and PS_AE_TIMINGS_DT.

How to interpret the info out from these AE SQL timings tables? e.g. for BAT_DTL_TYPE column on PS_AE_TIMINGS_DT table

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.