E-AE: How to Avoid Timeouts Or Deadlock On PS_AEONLINEINST When CallAppEngine() Using Online Temp Tables (Doc ID 651316.1)

Last updated on AUGUST 12, 2016

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***


Goal

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?

Solution

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