select namespace name,

gets,

gethits,

round(gethitratio*100,2) "GetHit Percentage",

pins,

pinhits,

round(pinhitratio*100,2) "PinHit Percentage",

reloads,

invalidations

from v$librarycache

order by 1;  

==

위를 c:\anal.sql로 저장을 했습니다.

SQL> @c:\anal.sql