I’m polling a stored procedure on an Oracle Database. The table I’m reading from is fed by a trigger on an ERP table (can’t touch the real table, only a “copy”)
There is a HUGE amount of data in the table, so I’m just grabbing the first 1k records every 2 min. I sometimes get behind during big commits, but I always catch up within a few minutes.
Once in a while we are seeing ORA-02049: timeout: distributed transaction waiting for lock.
Has anyone else dealt with this? I can post my procedures if that will help.