title: Oracle Deadlock
body: <p>Recently I am seeing some deadlock randomly once or twice a day, so I looked at the code &amp; we are putting the code in a single transaction.  At the same time I want to increase the ini_trans to 5 on Oracle so it can handle concurrent access.  The application is using "app_user" schema which calls "app_admin" schema (app_admin owns the table) &amp; the database is concurrently accessed by multiple application instances at the same time. Should I increase the ini_trans on app_user or app_admin or both?.  Thanks.</p>