Oracle Exadata Growth Story...

First exadata box V1 released in 2008 with the combination of Oracle software and HP hardware. Since that time Oracle came up with multiple exadata version with improved hardware and software. 

Oracle Exadata X6-2 released in Arpil-2016 which is the 7th generation of exadata. Since 2008 its first release V1, exadata gone under a number of significant changes in terms of resource performance and capacity. 

You can go through our earlier post for more detailed history of Exadata.

"The Only Permanent in Life is Change"

Following graphs will give you better understanding of exadata growth from V1 to X6 release. This article will also helps to the folks who are preparing for the certification.

Oracle Exadata Release Year:

Note: Growth given based on a full rack configuration of 14 storage servers, 8 compute servers.

Growth pattern for Database server memory:

Growth pattern for Database server CPU:

Growth pattern for Storage server CPU:

Growth pattern for Storage size:

Growth pattern for Flashcache:

Growth pattern for dataload rate:

Growth pattern for connectivity:

Be connected, we will continue the success story with next version :)

You would also like:

• History of Oracle Exadata Database Machine
• Importance of Exadata Certification
• Oracle Exadata Interview Experience

Exadata X4 series launched

                      http://www.oracle.com/us/corporate/press/2079925

Cellcli - Alter

CellCLI> alter cell shutdown services rs --> To shutdown the Restart Server service 
CellCLI> alter cell shutdown services MS --> To shutdown the Management Server service 
CellCLI> alter cell shutdown services CELLSRV --> To shutdown the Cell Services 
CellCLI> alter cell shutdown services all -->To shutdown the RS, CELLSRV and MS services 
CellCLI> alter cell restart services rs 
CellCLI> alter cell restart services all 
CellCLI> alter cell led on
CellCLI> alter cell led off 
CellCLI> alter cell validate mail
CellCLI> alter cell validate configuration 
CellCLI> alter cell smtpfromaddr='cell07@orac.com' 
CellCLI> alter cell smtpfrom='Exadata Cell 07' 
CellCLI> alter cell smtptoaddr='satya@orac.com' 
CellCLI> alter cell emailFormat='text' 
CellCLI> alter cell emailFormat='html' 
CellCLI> alter cell validate snmp type=ASR - Automatic Service Requests (ASRs) 
CellCLI> alter cell snmpsubscriber=((host='snmp01.orac.com,type=ASR')) 
CellCLI> alter cell restart bmc - BMC, Baseboard Management Controller, controls the compoments of the cell. 
CellCLI> alter cell configure bmc 
CellCLI> alter physicaldisk 34:2,34:3 serviceled on
CellCLI> alter physicaldisk 34:6,34:9 serviceled off 
CellCLI> alter physicaldisk harddisk serviceled on 
CellCLI> alter physicaldisk all serviceled on 
CellCLI> alter lun 0_10 reenable 
CellCLI> alter lun 0_04 reenable force 
CellCLI> alter celldisk FD_01_cell07 comment='Flash Disk' 
CellCLI> alter celldisk all harddisk comment='Hard Disk' 
CellCLI> alter celldisk all flashdisk comment='Flash Disk' 
CellCLI> alter griddisk RECO_CD_10_cell06 comment='Used for Reco'
CellCLI> alter griddisk all inactive 
CellCLI> alter griddisk RECO_CD_11_cell12 inactive 
CellCLI> alter griddisk RECO_CD_08_cell01 inactive force 
CellCLI> alter griddisk RECO_CD_11_cell01 inactive nowait 
CellCLI> alter griddisk DATA_CD_00_CELL01,DATA_CD_02_CELL01,...DATA_CD_11_CELL01 inactive 
CellCLI> alter griddisk all active 
CellCLI> alter griddisk RECO_CD_11_cell01 active 
CellCLI> alter griddisk all harddisk comment='Hard Disk' 
CellCLI> alter ibport ibp2 reset counters
CellCLI> alter iormplan active 
CellCLI> alter quarantine 
CellCLI> alter threshold DB_IO_RQ_SM_SEC.PRODB comparison=">", critical=100 
CellCLI> alter alerthistory

Cellcli - Describe

It Will display all attributes

CellCLI> describe cell

CellCLI> describe physicaldisk

CellCLI> describe lun

CellCLI> describe celldisk

CellCLI> describe griddisk

CellCLI> describe flashcache

CellCLI> describe flashcachecontent

CellCLI> describe metriccurrent

CellCLI> describe metricdefinition

CellCLI> describe metrichistory 

Exadata X-2 Sizing

Quarter Rack

1. 2 x Database Servers, each with: 

Includes:

- 2 x Six-Core Intel® Xeon® X5675 (3.06 GHz)
- 96 GB Memory (expandable to144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies 

2. 3 x Exadata Storage Servers X2-2 with 12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 36 CPU cores for SQL processing
- 1.1 TB Exadata Smart Flash Cache
- 2 x 36 port QDR (40 Gb/sec) InfiniBand Switches 

3. 2 x 36 port QDR (40 Gb/sec) InfiniBand Switches

Half Rack

1. 4 x Database Servers

Includes:

- 2 x Six-Core Intel® Xeon® X5675 Processors (3.06 GHz)
- 96 GB Memory (expandable to 144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies

2. 3 x 36 port QDR (40 Gb/sec) InfiniBand Switches

3. 7 x Exadata Storage Servers X2-2 with12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 84 CPU cores for SQL processing
- 2.6 TB Exadata Smart Flash Cache

Full Rack 

1. 8 x Database Servers

Includes:

- 2 x Six-Core Intel® Xeon® X5675 Processors (3.06 GHz)
- 96 GB Memory (expandable to 144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies

2. 3 x 36 port QDR (40 Gb/sec) InfiniBand Switches

3. 14 x Exadata Storage Servers X2-2 with 12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 168 CPU cores for SQL processing
- 5.3 TB Exadata Smart Flash Cache 

Additional Hardware :

All the rack will includes:

- Ethernet switch for administration of the Database Machine
- Keyboard, Video or Visual Display Unit, Mouse (KVM) hardware for local administration
- 2 x Redundant Power Distributions Units (PDUs)
- 42U rack packaging

History of Exadata

First Oracle's exadata was released in 2008 known as hardware and software engineered to work together. Since than we have seen 6 release of exadata machine with improved the combination of hardware and software. Latest X5-2 released in 2015. Here we have given short history of each version from V1 to X5-2.

V1: The first Exadata was released in 2008 and labeled as V1. It was a combination of HP hardware and Oracle software. There were no flash cache used in this version. At that time Exadata was made specially for Data ware housing only. This product was not accepted widely as it was suffered from overheating. 

V2: After V1 Oracle has launched Exadata V2 in 2009. It was a combination of Sun hardware and Oracle software. Here in V2 Oracle has upgraded storage cell with 384 GB of Exadata smart cache. Many o the customer has changed the Exadata from V to V2 because of the overheating problem in Exadata V1.

X2: This is the third edition of Oracle Exadata released in 2010.There are two version X2-2 stands for dual core CPUs and X2-8 stands for 8 core CPUs database server. This version is supporting both OLTP and Data warehouse. Also this has massive features compare to older Exadata in terms of CPUs, Memory, Compression, Smart scan etc...

X3: This is the forth edition of Exadata released in 2012. There is no much more difference between X2 and X3 except in CPU and RAM. This version has more RAM and CPU power then the previous one.

X4: It was released in 2013. In this version processing was increased to 2×12 core CPUs. It had the capacity to upgrade memory to 512GB in a compute node. Flash and disk storage was also increased. It featured a new model of high-capacity disk. 600GB disks were retired, and included 1.2TB, 10,000 RPM disks. These disks were a smaller form factor (2.5” vs 3.5”). The other big change with the X4-2 was the introduction of an active/active InfiniBand network connection. On the X4-2, Oracle broke the bonded connection and utilized each InfiniBand port independently. This allowed an increased throughput across the InfiniBand fabric.

X5: It was announced in early 2015, the sixth generation of Exadata. The X5-2 was a dramatic change in the platform, removing the high-performance Disk option in favor of an all-flash, NVMe (Non-Volatile Memory Express) model. High-capacity disk sizes remain the same at 4TB per disk. The size of the flash cards doubled to 6.4TB per storage server. Memory stayed consistent with a base of 256GB, upgradeable to 768 GB, and the CPU core count increased to 18 cores per socket. With X5, customers are allowed to purchase X5-2 with any configuration required—a base rack begins with two compute nodes and three storage servers.