rollback.sql

select name, gets, waits, ((gets-waits)*100)/gets hits
from v$rollstat s,
     v$rollname n
where s.usn = n.usn;