Oracle Exadata
Version 11.2.0.3

General Information
Note: Information on Exadata software is going to be written to multiple locations in the library: at least for now. I may later collect it, or replicate it, in one place. Let me know what would be best for you using the site.
 
1/4 Rack Exadata rolled off the delivery pallet
   
Flash Cache  
Smart Scan col stat_value format 9,999.9999

SELECT DECODE(name,
              'cell physical IO bytes saved by storage index', 'SI Svings',
              '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 interconnect bytes returned by smart scan',
               'cell physical IO interconnect bytes returned by smart scan');
Storage Indexing  
Function Offloading SELECT name
FROM v$sqlfn_metadata
WHERE offloadable = 'YES';
CELLCLI Commands  
   

Related Topics
DBMS_SQLPA.CANCEL_ANALYSIS_TASK (Overload 4)
Hybrid Columnar Compression
Partitioning
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved