Gabuc000 Member since 2012 5 posts
Posted: April 24, 2018
Last activity: April 25, 2018

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.

Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn