SQL> SELECT namespace ,(100*gethitratio ) hit_ratio    FROM v$librarycache;

NAMESPACE        HIT_RATIO
--------------- ----------
SQL AREA        50.3694248
TABLE/PROCEDURE 99.9740047
BODY            99.1189027
TRIGGER         99.9983301
INDEX           97.1096594
CLUSTER         99.9637897
OBJECT                 100
PIPE                   100
JAVA SOURCE            100
JAVA RESOURCE          100
JAVA DATA              100

11 rows selected.

col c1 heading 'Object|Name' format a30
col c2 heading 'Operation' format a15
col c3 heading 'Option' format a15
col c4 heading 'Index|Usage|Count' format 999,999
break on c1 skip 2
break on c2 skip 2

select
   p.object_name c1,
   p.operation c2,
   p.options c3,
   count(1) c4
from
   dba_hist_sql_plan p,
   dba_hist_sqlstat s
where
   p.object_owner <> 'SYS'
and
   p.operation like '%INDEX%'
and
   p.sql_id = s.sql_id
group by
   p.object_name,
   p.operation,
   p.options
order by
   1,2,3;