oracle允许未提交的读取选项?

前端之家收集整理的这篇文章主要介绍了oracle允许未提交的读取选项?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
在db2中,使用’with ur’子句的查询允许查询为未提交的读取,mysql中的’with nolock’子句也是如此.在oracle里有没有这样的选择?如果不是为什么?
汤姆提供了一个很好的答案: On Transaction Isolation Levels

他说:

The READ UNCOMMITTED
isolation level allows dirty reads.
Oracle Database doesn’t use dirty
reads,nor does it even allow them.
The basic goal of a READ UNCOMMITTED
isolation level is to provide a
standards-based definition that allows
for nonblocking reads.

Now,a database that allowed a dirty
read … not only does it return the
wrong answer,but also it returns … [an answer] … that never existed in the table.
In a multiuser database,a dirty read
can be a dangerous feature.
Personally,I’ve never seen the
usefulness of it…

The point here is that dirty read is not a feature; rather,it’s a liability. In Oracle Database,it’s just not needed. You get all of the advantages of a dirty read—no blocking—without any of the incorrect results.

猜你在找的Oracle相关文章