ora-02049

TransactionScope and Error: ORA-02049

I have the following routine: For j = 1 To NumItems dbValueLookup.Load(j) Using scope As New TransactionScope() For i = firstIndex To lastIndex 'dbValueLookup is basically just a Dictionary of items already in the DB If dbValueLookup.ContainsKey(i) Then 'updateData is a subroutine that updates this row w...

How to troubleshoot ORA-02049 and lock problems in general with Oracle

I am getting ORA-02049 occasionally for some long-running and/or intensive transactions. There is seemingly no pattern to this, but it happens on a simple INSERT. I have no clue how to get any sort of information out or Oracle, but there has to be a way? A log over locking or atleast a way to see current locks? ...