Storage Indexes - What they are. What they aren't.

Helper queries

Checking for I/O savings attributable to storage indexes (Arup Nanda):

col stat_value format 9,999.9999
select
  decode(name,
  'cell physical IO bytes saved by storage index',
  'SI Savings',
  'cell physical IO interconnect bytes returned by smart scan',
  'Smart Scan'
  ) as stat_name,
  value/1024/1024 as stat_value
from v$mystat s, v$statname n
where
  s.statistic# = n.statistic#
and
  n.name in (
  'cell physical IO bytes saved by storage index',
  'cell physical IO interconnect bytes returned by smart scan'
  )

Troubleshooting

References

Smart Scans Meet Storage Indexes By Arup Nanda

"Exadata and the Query Optimizer" Posts by Christian Antognini Part 1 | 2 | 3 | 4

Mapping of Physical Disk, LUNS, Cell Disks, and Grid Disks