E-AE: How to Avoid Timeouts Or Deadlock On PS_AEONLINEINST When CallAppEngine() Using Online Temp Tables
Last updated on JANUARY 19, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
Enterprise PeopleTools 8.1 and higher
This document was previously published as Customer Connection Solution 201027374
***Checked for relevance on 26-FEB-2012***
***Checked for relevance on 09-JAN-2015***
Users are experiencing time outs on PS_AEONLINEINST table from time to time, when multiple users are running online Application Engine program.
Sometimes PS_AEONLINEINST is apparently causing deadlocks, when DBAs are monitoring performance and are finding that the table PS_AEONLINEINST is consistently locked causing other sessions to wait.
Why does this happen and how to resolve it?
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 hundreds of Community platforms