0 Replies Latest reply: Jul 16, 2012 10:22 PM by tiplip RSS

    How to tune read lock in transaction?

    tiplip
      In [Transaction tuning|http://docs.oracle.com/cd/E17076_02/html/programmer_reference/transapp_tune.html] , I found,

      read locks
      Performing all read operations outside of transactions or at Degrees of isolation can often significantly increase application throughput. In addition, limiting the lifetime of non-transactional cursors will reduce the length of times locks are held, thereby improving concurrency.

      If I understand right, it means don't wrap read operation between tx_begin and tx_commit if I want to inprove concurrency, right?