This discussion is archived
0 Replies Latest reply: Jul 16, 2012 8:22 PM by tiplip RSS

How to tune read lock in transaction?

tiplip Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points