This content has been marked as final. Show 1 reply
1) The access over the DB link may take more time than the access on the remote DB to the MV there, so the effect of that flash caching may not be so noticeable.
2) It is likely that the container tables of the MVs are flash cached automatically by the cells, if that seems sensible.
3) You can very easy check out if ALTER TABLE MV-Container-Table-Name STORAGE (CELL_FLASH_CACHE KEEP) makes a difference
"Don't believe it, test it!"