Exadata
Installation and Configuration Topics
Exadata Machine 12.1 Installation and Config Guide
Oracle ASM Considerations for Exadata Upgrades
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
Storage Cell Architecture and Troubleshooting
Clearing the Exadata Flash Cache
References
Smart Scans Meet Storage Indexes By Arup Nanda
"Exadata and the Query Optimizer" Posts by Christian Antognini Part
1 |
2 |
3 |
4