v$rowcache Queries
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#
;


Library Cache

Buffer Cache

Oracle registered trademark of Oracle Corporation.

Last Revised On: July 17th, 2014

  355