SELECT
 cache#, parameter, count, gets, getmisses, usage, fixed
FROM v$rowcache
;

SELECT
 cache#,
 SUM(gets - getmisses - usage - fixed)/SUM(gets) row_cache
FROM v$rowcache
GROUP BY cache#
;