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