Application designers and developers should choose an isolation level based on
application performance and consistency needs as well as application coding
For environments with many concurrent users rapidly submitting transactions,
designers must assess transaction performance requirements in terms of the expected
transaction arrival rate and response time demands. Frequently, for high-performance
environments, the choice of isolation levels involves a trade-off between consistency
Application logic that checks database consistency must take into account the fact that
reads do not block writes in either mode.
Oracle isolation modes provide high levels of consistency, concurrency, and
performance through the combination of row-level locking and Oracle’s multiversion
concurrency control system. Readers and writers do not block one another in Oracle.
Therefore, while queries still see consistent data, both read committed and serializable
isolation provide a high level of concurrency for high performance, without the need
for reading uncommitted data.
1. 在应用性能 , 一致性读要求 , 以及应用代码需求的基础上选择隔离级别
take into account 考虑[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-989862/，如需转载，请注明出处，否则将追究法律责任。