DBA Result Cache Objects and Dependencies

Description

Categories
Enginatics
Repository
GitHub
Shows result cache objects with the current number of cached results, the number of times these results were found and reused (scan count) and their dependency on objects causing the most frequent invalidations.

Warning !!!
Don't run this on a prod system during business hours as prior to DB version 12.2, selecting from v$result_cache_objects apparently blocks all result cache objects (see note 2143739.1, section 4.).
You may end up with all server sessions waiting on 'latch free' for 'Result Cache: RC Latch' while the report is running.

SQL 46 lines

Parameters 3

ParameterTypeList of values SQL
Result Name containsChar
lower(grco.name) like '%'||lower(:result_name)||'%'
Show DependenciesLOV
Y
I have read the warningLOV
:warning=:warning