Oracle Isolation Levels : Read committed (315)

最新推荐文章于 2025-11-18 15:56:56 发布

转载最新推荐文章于 2025-11-18 15:56:56 发布 · 184 阅读

文章标签：

#数据库

本文详细介绍了Oracle数据库中默认的事务隔离级别——已提交读取。在此级别下，每个事务内的查询仅能看到在查询开始之前已经提交的数据。此外，文章还解释了为何Oracle中的查询不会读取脏数据。

This is the default transaction isolation level. Each query executed
by a transaction sees only data that was committed before the
query (not the transaction) began. An Oracle query never reads
dirty (uncommitted) data.
Because Oracle does not prevent other transactions from
modifying the data read by a query, that data can be changed by
other transactions between two executions of the query. Thus, a
transaction that runs a given query twice can experience both nonrepeatable read and
phantoms.

Oracle隔离级别 : 已提交读取
1. Oracle默认的事务隔离级别
2. 事务内执行的查询只能看到查询执行前就已经提交的数据. Oracle 的查询永远不会读取脏数据

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-988995/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-988995/