SELECT 'Index to Table Ratio ' "Ratio",
ROUND ( (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME LIKE 'index fast full%'
OR NAME = 'index fetch by key'
OR NAME = 'table fetch by rowid')
/ (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME IN
('table scans (short tables)',
'table scans (long tables)'
)),
0
)
|| ':1' "Result"
FROM DUAL;