Locations of visitors to this page

Tuesday, February 22, 2011

Distributed read consistency 分布式读一致性

Distributed read consistency 分布式读一致性

据文档Managing Read Consistency称,在分布式环境中,由于SCN不同步,会导致读出旧数据。比如:远端数据库更新了一个表的记录,并提交。然后,本地数据库通过数据库链接查询该表,得到的是更新前的数据,再次查询才得到更新后的数据。

多次试验后均未能重现文档所描述的现象,总是能读出最新提交的数据,原因不明。


外部链接:
Distributed Query Returns Different Results on Consecutive Runs when no Changes Exist in the Base Tables. [ID 561471.1]
Bug 6933259: DISTRIBUTED QUERY RETURNS WRONG RESULTS
Bug 611416: SELECT AFTER UPDATE AND COMMIT DOESN'T SHOW UPDATED COLUMNS



-fin-

No comments:

Website Analytics

Followers