Script: result_cache_statistics.sql
( Download Script )
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/11g/result_cache_statistics.sql
-- Author : Tim Hall
-- Description : Displays result cache statistics.
-- Requirements : Access to the V$ views.
-- Call Syntax : @result_cache_statistics
-- Last Modified: 07/11/2012
-- -----------------------------------------------------------------------------------
COLUMN name FORMAT A30
COLUMN value FORMAT A30
SELECT id,
name,
value
FROM v$result_cache_statistics
ORDER BY id;
CLEAR COLUMNS