materialized view log 中的cache|nocache是啥意思 英文没看懂。
CACHE | NOCACHEFor data that will be accessed frequently, CACHE specifies that the blocks retrieved for this log are placed at the most recently used end of the least recently used (LRU) list in the buffer cache when a full table scan is performed. This attribute is useful for small lookup tables.NOCACHE specifies that the blocks are placed at the least recently used end of the LRU list. The default is NOCACHE.
CACHE | NOCACHEFor data that will be accessed frequently, CACHE specifies that the blocks retrieved for this log are placed at the most recently used end of the least recently used (LRU) list in the buffer cache when a full table scan is performed. This attribute is useful for small lookup tables.NOCACHE specifies that the blocks are placed at the least recently used end of the LRU list. The default is NOCACHE.
例如：
SELECT /*+FULL(BSEMPMS) NOCAHE(BSEMPMS) */ EMP_NAM FROM BSEMPMS；