这有点奇怪,在官方文档中,status函数返回的值是以下之一: STATUS_DISA - Cache is not available STATUS_ENAB - Cache is available STATUS_BYPS: Cache has been made temporarilyunavailable. STATUS_SYNC - Cache is available, but synchronizing with Oracle RAC nodes怎么会出现corrupt...查看下result cache当前的使用情况 v$result_cache_statistics 以及 dbms_result_cache.memory_report
我参看过DBMS_RESULT_CACHE确实有一个状态是CURRUPT的。STATUS_CORR CONSTANT VARCHAR2(10) := 'CORRUPT';oracle version is 11.2.0.3.0谢谢。
result_cache_max_size 419456k
STATUS_DISA - Cache is not available
STATUS_ENAB - Cache is available
STATUS_BYPS: Cache has been made temporarilyunavailable.
STATUS_SYNC - Cache is available, but synchronizing with Oracle RAC nodes怎么会出现corrupt...查看下result cache当前的使用情况
v$result_cache_statistics
以及
dbms_result_cache.memory_report