doQueryDiagnostics

gopal122

Member
Hi All,

We have a problem for one UBE getting failed on enterprise server with jde.log stating
doQueryDiagnostics: The following SQL query took 125 seconds which is equal to or greater than QueryExecutionTimeThreshold (5 seconds) for E1User(***) with DBProxyUser(***).

Currently we are on 9.1.5 and Db is 11gR2

I didn't dig much into it till now . But if commit for transaction is happening slow or late . It should focus on other UBE's as well . Guys please do share some thoughts, if encountered this issue previously .
Note: We can't change in ini file
[DB SYSTEM SETTINGS]
QueryExecutionTimeThreshold=10

Thanks .
 
Back
Top