0 Replies Latest reply on Jul 17, 2012 3:22 AM by tiplip

    How to tune read lock in transaction?

      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?