SELECT name, gets, waits,
       ((gets - waits) * 100) / gets hit_ratio
FROM   v$rollstat S,
       v$rollname R
WHERE  S.usn = R.usn