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.
Can you please let us know the exact SQLs statement being run? I understand that you may be running the queries using the connect-SQL rule. Please provide the screenshot of the same and log file snippet.