Check in V$LOCKED_OBJECT. If the row is locked , the table name will appear in this view. Ensure that row locking is enabled in the INIT.ORA file. In case of deadlock, oracle will automatically rollback one of the transactions.