Oracle Exadata Database Machine X4 focuses on Online Transaction Processing

Oracle Exadata Database Machine X4, its fifth-generation flagship database machine, on Wednesday unveiled new hardware and software that focuses on Online Transaction Processing (OLTP).

The new update is expected to accelerate performance, increase capacity, and improve efficiency and quality of service for database deployments, said Oracle in a statement.

Besides OLTP, Oracle says the new release focuses on database consolidation and data warehousing. The new update is designed to help enterprises simplify the biggest database challenges. It includes performance increases between 50 and 100 percent and storage capacity increases between 33 and 100 percent.

Since the launch of Oracle Exadata, the first generation, in 2008, there are thousands of Oracle Exadata Database Machine’s powering several businesses worldwide, running workloads including petabyte data warehouses, real-time OLTP, business applications, e-commerce, and online financial trading.

Oracle Exadata Database Machine

Oracle has improved the performance of OLTP-oriented workloads by quadrupling the flash memory capacity through a combination of larger physical flash and high-speed flash compression. A single rack Oracle Exadata now supports 88TB of user data in Flash. This capacity is sufficient to hold the vast majority of OLTP databases entirely in flash memory.

Random I/O rates that are critical for OLTP applications have been improved close to 100 percent to 2.66 million 8K database reads and 1.96 million writes, even with full flash compression enabled. The ability to perform compression at millions of I/Os per second breaks the long standing trade off between high performance and high efficiency. Data throughput of a single rack Oracle Exadata is 100 GB/sec. This throughput greatly exceeds that of all-flash arrays while retaining the benefits of low cost disk tiering.

Oracle has enhanced performance of Data Warehousing workloads by new Flash Caching algorithms that focus on table and partition scan workloads that are common in Data Warehouses. Tables that are larger than flash are now automatically partially cached in flash and read concurrently from both flash and disk to speed throughput.

The capacity of Oracle Exadata allows hundreds of databases to be consolidated in a single rack, enabling greatly reduced costs and improved agility.

In addition, Oracle Exadata now has the unique ability to prioritize requests as they flow from database servers, through network adapters and network switches, to storage, and back. Oracle Exadata uses a new generation of InfiniBand network protocols to ensure that network-intensive workloads such as reporting, batch and backups do not delay response-time sensitive interactive workloads.

Improvement Highlights

The Oracle Exadata Database Machine X4 offers 77 percent to 100 percent increase in Database I/Os per second. Up to 2.66 million read IOPs per full rack. Up to 1.96 million write IOPs to flash. Oracle Exadata flash throughput greatly exceeds that of all-flash arrays.

50 percent increase in database compute performance on X4-2 systems using two 12-core Intel Xeon Processors E5-2697 v2.

Close to 100 percent increase in InfiniBand network throughput and the addition of Network Resource Management to ensure ultra-low response times for latency critical database operations even when there are network intensive reporting, batch, or backup operations running in parallel.

The Oracle Exadata Database Machine X4 offer 100 percent increase in physical PCI Flash capacity to 44 TB per full rack.

Up to another 100 percent increase in logical flash cache capacity to 88 TB per full rack. Unique Exadata Flash Cache Compression transparently compresses database data into flash using hardware acceleration to compress and decompress data with zero performance overhead at millions of I/Os per second. Flash cache compression is effective for both OLTP and DW databases.

100 percent increase in maximum memory capacity on X4-2 to 4 TB per full rack using memory expansion kits enables greater consolidation.

100 percent increase in high performance disk storage capacity to over 200 TB per full rack.

33 percent increase in high capacity disk storage capacity to 672 TB per full rack. Using Oracle Exadata compression technologies, petabytes of user data can be stored per rack.

[email protected]