Sitting in on Sun Exadata Storage Engine Class

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.


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

This blog is my perspective of Sun in relation to Oracle, MySQL, Oracle Fusion Middleware, Education and Virtual Reality platforms. The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today