Adrian Angelov wrote:You make a good point, Adrian. In our initial testing, it looked like my querying v$result_cache_objects resulted in latches for all the running processes at the time. It was very odd. And I have a tough time killing the offending session, too.
Do not do it on a production database because of the following bug: Bug 14665745 Excessive "Result Cache: RC Latch" latch gets using DBMS_RESULT_CACHE.memory_report
(it leads to database hang on a busy database when you run select on v$result_cache_objects or memory_report)