Discussion Board

Serializable isolation Oracle serializable mode is compatible with SQL92 and offers many benefits compared with read-locking implementations. It does not provide semantics identical to such systems. Application designers must take into account the fact that reads in Oracle do not block writes as they do in other systems. Transactions that check for database consistency at the application level can require coding techniques such as the use of SELECT FOR UPDATE. This issue should be considered when applications using serializable mode are ported to Oracle from other environments. Prajakta Pandit 03-3-2017 12:02 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*