Smart Scans

on May 9, 2013 at 11:03 am
Posted In: Oracle Exadata (Cat)

SELECT (a.value+b.value)/c.value as efficiency
FROM v$sysstat a, v$sysstat b, v$sysstat c

WHERE a.name = ‘cell IO uncompressed bytes’

AND b.name = ‘cell physical IO bytes saved by storage index’

AND c.name = ‘cell physical IO interconnect bytes returned by smart scan’;

EFFICIENCY

———-

45.9