A useful way to view the read committed and serializable isolation levels in Oracle is
to consider the following scenario: Assume you have a collection of database tables (or
any set of data), a particular sequence of reads of rows in those tables, and the set of
transactions committed at any particular time. An operation (a query or a transaction)
is transaction set consistent if all its reads return data written by the same set of
committed transactions. An operation is not transaction set consistent if some reads
reflect the changes of one set of transactions and other reads reflect changes made by
other transactions. An operation that is not transaction set consistent in effect sees the
database in a state that reflects no single set of committed transactions.
Oracle provides transactions executing in read committed mode with transaction set
consistency for each statement. Serializable mode provides transaction set consistency
for each transaction.
事务集一致性
1. 一个数据库操作中所有读取返回的数据是由同一组已提交事务写入的
2. 在已提交读取隔离模式下,Oracle能保证每个语句的事务集数据一致性.在串行化隔离模式下,
Oracle能保证每个事务的事务集数据一致性
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-989546/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-989546/