title: How to troubleshoot ORA-02049 and lock problems in general with Oracle
body: <p>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.</p>
  
  <p>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?</p>