or something like that, but not all executions are SQL executions:
select ( SUM (DECODE (NAME, 'table scans (long tables)', VALUE, 0))
+ SUM (DECODE (NAME, 'table scans (short tables)', VALUE, 0))
)
/ SUM (DECODE (NAME, 'execute count', value,0))
from v$sysstat
where name in (
'execute count'
,'table scans (long tables)'
,'table scans (short tables)'
)
