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-
Tuesday, February 22, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment