Boosting Oracle Database Performance with Persistent Memory Technology
Track
DBA & Infrasturcture
Date and time
-
Room
-
Duration
60'
The Latest Persistent Memory such as Intel Optane DC 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. When PMEMs are configured in application direct mode, they can be used to store database files and redo logs. This presentation will discuss the use cases of PMEMs in these two modes for Oracle Database:1) In memory mode use PMEMs for Oracle In Memory store 2) in Application direct mode to store the database files. We will show the significant performance benefits that can be achieved from either of these two modes. We will discuss how Oracle 20c Persistent Memory database with Persistent Memory Filestore feature is used with PMEMs Application mode. We will also discuss how PMEMs are used in Oracle Exadata X8M to achieve the great database performance.
Lecture details
About speaker
Kai Yu, author
Kai Yu is a Distinguished Engineer of Dell Technical Leadership Community, in Dell Technologies Inc. Kai has 26 + years’ experience of architecting and implementing various IT solutions by specializing in Oracle database, Oracle Analytics , Oracle EBS, virtualization and Cloud. Kai has been a frequent speaker at various IT/Oracle conferences and several Oracle OTN/Groundbreaker tours with over 180 presentations. He also authored many articles in technical journals such as IEEE Transactions on Big Data, and co-authored Apress book “Expert Oracle RAC12c”. Kai has volunteered as Quest/IOUG conference committee member , IOUG RAC SIG president and Quest/IOUG Cloud SIG co-founder and the current 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/.