The instance maintains database buffer cache, dict cache etc for better performance of the data/sql statements that are used in the subsequest access
In RAC, where we have multiple instances, how these caches work ?
Like I updated Tab1's data and this query was served by instance A. This is stored in the buffer cache of instance A.
Will this get copied to that of instance B ?
If yes, then how ? The OCFS and raw partition etc all talk about talking to the database, not inter-instance communication
If no, then the subsequest access to Tab1 table, if served by instance B, will fetch the stale data and will defeat the purpose of cache and performance gain etc