Can anyone please explain how data consistency is handled in a multi-instanced Oracle Database when multiple users across the instances are trying to access the same data ? Thanks!
任何人都可以解释当实例中的多个用户试图访问相同数据时,如何在多实例Oracle数据库中处理数据一致性?谢谢!
1 个解决方案
#1
2
Oracle uses a technique called Cache Fusion (see for example here) to exchange “dirty” cached blocks between the instances when they are needed elsewhere.
Oracle使用一种名为Cache Fusion的技术(例如,参见此处),在其他地方需要实例时,在实例之间交换“脏”缓存块。
This is relevant only when data are written — as long as everybody reads, there is no problem.
这只有在写入数据时才有意义 - 只要每个人都读,就没有问题。
#1
2
Oracle uses a technique called Cache Fusion (see for example here) to exchange “dirty” cached blocks between the instances when they are needed elsewhere.
Oracle使用一种名为Cache Fusion的技术(例如,参见此处),在其他地方需要实例时,在实例之间交换“脏”缓存块。
This is relevant only when data are written — as long as everybody reads, there is no problem.
这只有在写入数据时才有意义 - 只要每个人都读,就没有问题。