PART 2 :EXADATA V2 - Overview

1).Infiband

• Only Storage Network Supported by Exadata
• Provides Highest Possible performance available - 40Gb/Sec each direction.
• Uses ZDP Protocol (Zero Data Loss UDP Protocol) - Open Source Developed by Oracle Corp
• Can also be used as RAC interconnect.
• Each Infiband Link is able to carry the full data bandwidth of the entire Cell

2).Exadata comes to 2 DISK Type - SAS and SATA.

• SAS - For Maximum Performance
• SATA -For Maximum Capacity

3).Sun Database Machine doesn't include any software licence.

4).Sun Database Storage Server Details :

• RAM - 72 GBP(18 x4 )
• Disk Drives - 584 GB ( 4 x 2.5 146 GB)
• Oracle Enterprise Linux
• Oracle Database 11.2

5).A Full Rack Exadata can have 8 Database Servers,14 exadata cells,3 Infiband Switches

6).SQL Offloading is done by Database Server using iDB(Oracle Data Transfer Protocol)

7).CELLSRV component of Exadata storage server is used for Smart scan processing.CELLSERV Scans the blocks from storage and extract the relevant columns and send it back to the database server.

8).Database Server can break the SQL query and send the small portion of it to each exadata cells and upon retrieving the
results ,Database Server constructs the results and required rows are returned to clients.

9).We can use the below query to find the list of functions which can be offloaded to the Exadata.

Select * from v$sqlfn_metadata where offloadable='YES'

10).Exadata Storage server can perform Smart scans on encrypted tablespace and Columns.

11).With Performance of incremental Backup performance is significantly improved as the changes are tracked from individual block level rather than the large group of blocks.