select username, (1-(physical_reads/(consistent_gets+block_gets)))*100 "Buffer Cache Hit Ratio"
from v$session se, v$sess_io si
where se.sid = si.sid
and (consistent_gets+block_gets) > 0
and username is not null
order by username
/