By George Trujillo on Jan 12, 2010
I recently sat in on a Sun Storage Exadata Storage Engine class focusing on the Sun hardware. It was great to sit in on a class where you could listen to Sun SEs talk about the hardware and to get their insights. As a DBA it always helps to have a deeper understanding of the environment surrounding an Oracle database server.
Everything surrounding this design is about incredible speed and scalability. Databases in general when they need to get a record, actually load an entire block or page into memory. Each block can range from a 2k to a 16k block. Letting the storage services load the record needed instead of the entire block it resides in is incredibly important in this age of rapidly growing databases. A few components and features that stand out:
- Runs on Oracle Enterprise Linux and Oracle 11gR2
- Smart Flash Cache
- Infiniband connectivity
- Excellent redundancy across ports, power supplies, striping, etc.
- Impressive hybrid columnar compression
- Query processes done on storage side instead of server side. Smart scans and storage indexes greatly reduce I/O.
- Hybrid columnar compression for 10 to 50 times greater data compression
- Smart Scans on compressed data for even faster query execution
- Storage Indexes to further reduce disk I/Os
- Uses ASM for storage
- Offloading of query processing to storage using Smart Scans
It was fun to listen to debates and discussions on different topics such as who should manage the ASM storage: Oracle DBAs, storage team or Unix administrators. :) Excellent class and instructor.