Script: result_cache_status.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/11g/result_cache_status.sql -- Author : Tim Hall -- Description : Displays the status of the result cache. -- Requirements : Access to the DBMS_RESULT_CACHE package. -- Call Syntax : @result_cache_status -- Last Modified: 07/11/2012 -- ----------------------------------------------------------------------------------- SELECT DBMS_RESULT_CACHE.status FROM dual;