Referential Integrity (324)

tsinglee發表於2007-12-07

Because Oracle does not use read locks in either read-consistent or serializable
transactions, data read by one transaction can be overwritten by another. Transactions
that perform database consistency checks at the application level cannot assume that
the data they read will remain unchanged during the execution of the transaction even
though such changes are not visible to the transaction. Database inconsistencies can
result unless such application-level consistency checks are coded with this in mind,
even when using serializable transactions.

引用完整性
1. 無論在已提交讀取隔離模式還是序列化隔離模式中,Oracle 都不會使用讀取鎖

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-989548/,如需轉載,請註明出處,否則將追究法律責任。

相關文章