select a.inst_id, b.total_io, a.flash_io, a.flash_io/b.total_io as quality

from (SELECT inst_id, value as flash_io FROM GV$SYSSTAT WHERE NAME IN (‘cell flash cache read hits’)) a,

(SELECT inst_id, value as total_io FROM GV$SYSSTAT WHERE NAME IN (‘physical read total IO requests’)) b

where a.inst_id = b.inst_id order by a.inst_id

 

|INST_ID   TOTAL_IO          FLASH_IO    QUALITY

1      940,403,933       872,071,164           0.92

2      139,959,018       114,791,948           0.82

3        98,157,948        92,874,490           0.94

4      146,588,414       140,561,659           0.95