Last updated on JULY 13, 2015
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.
Following detection of performance issues related to frequent generation if v$session updates with MODULE and ACTION info for application engine programs,
those updates were made optional since PeopleTools 8.52.23, 8.53.13 and 8.54.xx, with a new configuration option EnableAEMonitoring, default value 0, see:
- Doc ID 1640355.1 - E-AE: Performance Degradation When Using Do Loop Action to Process Large Amount of Data on PT 8.52 & PT 8.53
- Doc ID 2008164.1 - E-AE: Undocumented New Property EnableAEMonitoring to Control V$SESSION Population for App Engine Processes
- Bug 21055279 - DOCUMENT ENABLEAEMONITORING AND RELATED BEHAVIOR CHANGE
- UNPUBLISHED Bug 16012402 - AE DO-SELECT SQL CAUSE EXCESSIVE SQL*NET MESSAGE TO CLIENT WAITS.
However to reenable the updates one has to enter the option manually, the domain source files ("psprcs.cfg", "psappsrv.cfg") as delivered do not contain it.
Request include that new parameter, with default value, EnableAEMonitoring=0, into the delivered "psprcs.cfg" and "psappsrv.cfg" file, ideally with a comment.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms