Join us for our monthly Oracle Database 19c Special Interest Group meeting!
Boosting Database Performance in Oracle 21c Database with Persistent Memory
Presented by Kai Yu, Dell Technologies
The Latest Persistent Memory such as Intel Optane Persistent Memory (PMEM) combines near-DRAM performance with the data persistence of storage. It can be configured in memory mode or application direct mode. When the memory mode is used, PMEMs can be considered as volatile and can be used as main memory and DRAM is treated as a write-back cache. PMEMs can also be configured in application direct mode to store database files and redo logs. This presentation will discuss the use cases of PMEM:
- In memory mode use PMEMs for Oracle In-Memory store
- In Application direct mode to store the database files, namely persistent Memory Database in Oracle 21c.
We will discuss the significant performance benefits that can be achieved from either of these two modes. We will discuss the Persistent Memory Database feature that includes directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore) in Oracle 21c. We will also discuss how PMEMs are used in Oracle Exadata X8M.
What you will learn from this presentation:
- The latest Persistent Memory and its great advantages for Oracle Database performance
- How Oracle Database can take advantage of the two modes of Persistent Memory and the Oracle Persistent Memory Database feature: directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore)
- The challenges, new features, and configuration best practices with Persistent Memory for Oracle Database 21c.
About Kai Yu
Kai Yu is a Distinguished Engineer of Dell Technical Leadership Community and mainly responsible for Dell EMC Oracle Solutions Engineering. Kai has 27 years experience of architecting and implementing various IT solutions by specializing in Oracle RAC database, Oracle BI and Oracle EBS, Virtualization/Cloud. Kai has been a frequent speaker at various IT/Oracle conferences and author of technical articles in technical journals such as IEEE Transactions on Big Data, and co-authored Apress book “Expert Oracle RAC12c” and the upcoming Apress book: “Machine Learning for Oracle Database Professionals – Deploying Model-Driven Applications and Automation Pipelines.”
Kai has volunteered in the Oracle community such as the IOUG conference committee, IOUG RAC SIG president, and Quest/IOUG Cloud SIG co-founder/vice president. Kai has been an Oracle ACE Director since 2010 and was featured as Oracle ACE Spotlight by OTN. He also received the 2011 OAUG Innovator of Year award the 2012 Oracle Excellence Award: Technologist of the Year: Cloud Architect by Oracle Magazine. Kai has shared all his technical articles and conference presentations on his Oracle blog: https://kyuoracleblog.wordpress.com/