What percent of I/O is from buffers?

-- Get % read cached

select dr.value dskreads,

br.value bufreads,

round ((( 1 - ( dr.value / br.value )) *100 ), 2) cached

from sysprofile dr, sysprofile br

where dr.name = "dskreads"

and br.name = "bufreads";

-- Get % write cached

select dw.value dskwrites,

bw.value bufwrites,

round ((( 1 - ( dw.value / bw.value )) *100 ), 2) cached

from sysprofile dw, sysprofile bw

where dw.name = "dskwrites"

and bw.name = "bufwrites"

Previous slide

Next slide

Back to first slide

View graphic version