SET pagesize 55;
SET linesize 100;
col namespace heading "Name" format a25;
col gethitratio format 9999999 heading "Get Hit|Ratio";
col pinhitratio format 9999999 heading "Pin Hit|Ratio";
col reloads format 9999999 heading "Reloads";
col invalidations format 9999999 heading "Invalid|Count";
 
SELECT namespace,
       gethitratio,
       pinhitratio,
       reloads,
       invalidations
FROM v$librarycache
ORDER BY reloads DESC, namespace
/