OracleExadata.概述.pptVIP

* * Key Takeaways Typical queries return entire rows from the storage servers into the database servers for SQL sums, filters, projections; Indices may help reduce the number of rows returned, but even then the entire row is returned. Other Points * * 表的几千个行形成一组，叫压缩单元 Compression Units (CU) 在压缩单元中，根据列组织数据，再压缩 将列举有相似值的数据放在一起，以提升压缩能力 对大量数据加载和查询很有好处 400 GB usable capacity 149K random IOPS and 2.1 GB/s throughput performance 95 microseconds write latency Proactive monitoring features Enterprise reliability Reduces power and improves server efficiency * * * * The best way to build a cloud is to let Oracle do it for you. Oracle Exadata is essentially a cloud in a box. It runs all the technology we’ve discussed in this seminar, including Oracle RAC, ASM, and Clusterware. It provides superior storage by utilizing the advanced Exadata storage servers. The net result is the perfect platform for consolidation into the database cloud. It combines servers, storage, networks into one integrated package where we have solved all the difficult integration problems, especially as it relates to providing the highest end-to-end performance. Database and Storage software is fully tuned and optimized for the above system to deliver orders of magnitude higher performance levels for both OLTP and DW. The system is modular and extensible, fully fault-tolerant and serviceable, and is made with low-cost high volume components that represents the industry’s most proven technology. ? ? A big part of our efforts in this area has been to produce a holistic management solution that provides an integrated view of both the hardware and software in an Exadata machine. There are a number of different schematic views in Enterprise Manager for Exadata. The hardware view provides a schematic like the screenshot shown here, of the cells, compute nodes and switches, as well as any alerts that have been generated for hardware components. The software or system view shows you the per