Exadata – Checking storage index usage

select name,value from v$sysstat where name in (‘physical read total bytes’,’cell physical IO bytes saved by storage index’);
or
select name , value/1024/1024 MB from v$statname n, v$mystat s where n.statistic# = s.statistic# and n.name in (‘cell physical IO interconnect bytes returned by smart scan’, ‘cell physical IO bytes saved by storage index’);
 
 
 

Scroll to Top