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

最新推荐文章于 2024-07-23 08:30:00 发布

转载最新推荐文章于 2024-07-23 08:30:00 发布 · 106 阅读

本文介绍了Oracle DBMS_RESULT_CACHE管理包的使用方法，包括如何设置旁路模式、刷新缓存、获取内存报告及无效化内容等。此包用于管理SQL结果缓存和PL/SQL函数结果缓存，两个缓存共用同一基础设施。

四， 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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1434063/