For prevening undesired locking
1. As far as possible do not exlussively lock the table.
2. Frequently commit (or Rollback) your transactions

Regards

Viraj
-----------
OCP 9i DBA