title: How can I automatically unlock tables in Oracle after a given time?
body: <p>I have a bit of code that connects to an Oracle database, locks a table, does some things to it and unlock it.<br>
  I would like to know that if my program was to freeze while a table was locked, the lock would release automatically.</p>
  
  <p>Is there any way to set up Oracle, to do this automatically?</p>
  
  <p>For example, I'm thinking of something that would say "If user x has maintained a lock on table y for over z seconds, rollback the transaction and release the table."</p>
  
  <p>If it isn't possible, is there anything else I can do to achieve the same results? Is this even an actual problem or am I just being paranoid?</p>
  
  <p>Thanks in advance.</p>