Doc

Name: LIB_HIT.sql

Author: Mahnho Han

Hit Ratio of Library

100%에 가까울수록 바람직

#

TTITLE 'The Library Hit Ratio'

select round(sum(pinhits)/sum(pins) * 100,2)

from v$librarycache;