PCIe SSD is an enterprise class high performance storage device. It is built with SLC NAND flashand designed for applications that require low latency and high IOPs (IO Per Second) operation.OLTP database workloads which require very low storage IO latency with many small randomread/write IO operations are the ideal cases to use PCIe SSDs to improve the performance.To understand how much PCIe SSDs can really improve OLTP database performance andthe related best practices, we have done a series of performance studies of using PCIe SSDfor various Oracle database configurations including PCI SSD as Oracle smart flash cache.This studies are based a single node Oracle 11g R2 database as well as a two node 11gR2Oracle Real Application clusters (RAC) database with Oracle Enterprise Linux 6.2 platform.This presentation is to examine each of these case studies and the compare the performanceimprovements of these cases.
What to learn:
Introduction to Solid State Disk technology and PCIe SSDs and their IO performancecharacteristics2. Use cases of using PCIe SSDs for Oracle database and the Performance analysis of the usecases3. The recommended best practices of using PCIe SSDs for optimizing Oracle databaseperformance
1.