oracle result_cache,Oracle 11.2.0.1 Result Cache 测试 - 12 DBMS_RESULT_CACHE管理包

四， DBMS_RESULT_CACHE管理包

使用DBMS_RESULT_CACHE包管理shared pool中的result cache区

The DBMS_RESULT_CACHE package provides an interface to allow the DBA to administer that part of the shared pool that is used by the SQL result cache and the PL/SQL function result cache. Both these caches use the same infrastructure. Therefore, for example, DBMS_RESULT_CACHE.BYPASS determines whether both caches are bypassed or both caches are used, and DBMS_RESULT_CACHE.FLUSH flushes both all the cached results for SQL queries and all the cached results for PL/SQL functions.

BYPASS

Sets the bypass mode for the Result Cache, When bypass mode is turned on, it implies that cached results are no longer used and that no new results are saved in the cache

FLUSH

Flushes all objects from result cache

Note: flushing shared pool has no affect

MEMORY_REPORT

Nice report that shows usage of result cache

STATUS

ENABLED or NOT ENABLED

INVALIDATE

Invalidate contents of the result cache

INVALIDATE_OBJECT

Invalidates contents that rely on object passed in

常见用法：

BEGIN

DBMS_RESULT_CACHE.BYPASS(TRUE);

DBMS_RESULT_CACHE.FLUSH;

END;

/

BEGIN

DBMS_RESULT_CACHE.BYPASS(FALSE);

END;

/

BEGIN

DBMS_RESULT_CACHE.INVALIDATE('HR','EMP');

END;

/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1434063/，如需转载，请注明出处，否则将追究法律责任。