Oracle SQL query runs fast directly but dies executed through Pega
We have ran oracle sql queries in oracle directly, once as a SQL statement and then as a stored procedure. Both SQL processes run in about 120 seconds on 1 million records.
But when we execute the SQL statement or stored procedure in Pega, the DBA connector times out and locks up the database. We see Oracle-01013 alert which is oracle stopped due to user request. The SQL never finishes before having stuck threads, connection timeout, and a locked database table.
There is no output from the stored procedure or the SQL statement. We have enough connections, 10 minutes on time out of DBA connections in WebLogic.
I am at a lose at what to try next.