BAT_TIMINGS_LOG

Return to Index

Table: PS_BAT_TIMINGS_LOG

Application Engine program writes performance metrics to this table and its children on successful completion of a program when the TraceAE flag is set to 1024.  This table contains one row per process.  Note: This table is not purged as a part of the process scheduler purge process.

PeopleSoft Field NameDescription
PROCESS_INSTANCEProcess Instance
PROCESS_NAMEName of the Process, same as PSPRCSRQST.PRCSNAME
OPRIDID of Operator who ran the process
RUN_CNTL_IDRun Control ID
BEGINDTTMDate/Time at which the process began.  Should be the same as PSPRCSRQST.BEGINDTTM
ENDDTTMDate/Time at which the process ended.  This may be a few seconds earlier that PSPRCSRQST.ENDDTTM which is updated again by the Distribution Server (see Life Cycle of a Process Request).
TIME_ELAPSEDOverall Elapsed Time (in milliseconds)
TIME_IN_PCTotal PeopleCode Time (in milliseconds)
TIME_IN_SQLTotal SQL Time (in milliseconds)
TRACE_LEVELTrace level (AE)
TRACE_LEVEL_SAMSAM Trace Level

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 25 July 2010