Oracle Database 19c June 2023 Meetup

Oracle Database 19c June 2023 Meetup -Eliminating database I/O latency with Oracle new Persistent Memory features

Speaker: Kai Yu, Distinguished Engineer, Dell Technologies

Abstract: Database I/O latency often posts significant performance bottlenecks on database systems. Oracle Persistent Memory database and the Oracle Memory Speed File system(OMS) introduced Oracle Database 21c and 19c respectively provide the support for Persistent Memory (PMEM) as database storage and significantly reduce database I/O Latency. By mapping database buffer cache directly onto Persistent Memory storage, Persistent Memory Database directly uses data residing in the Persistent Memory storage and eliminates the latency of copying data into the database buffer cache. This session discusses these two features in detail and how we leverage them to achieve the extremely low latency and high throughputs in a high performance database system. This session provides the step by step how-to details of implementing these two Persistent Memory database features, also provides the use cases & performance benefit studies of leveraging these Two features in a high performance database system. We will have some discussions on the Intel latest announcement on Persistent Memory technology and the related future development direction.