LIBRARY CACHE HIT RATIO

select sum (pinhits)/sum (pins)"hit ratio",
sum(reloads)/sum (pins) "reload percent"
from v$librarycache
where namespace in
('SQL AREA','TABLE/PROCEDURE','BODY','TRIGGER')