Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits | Tanel Poder Consulting

[utterances-bot]

Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits | Tanel Poder Consulting

Part 1 [this post], part 2.
Introduction Introduction My home lab Optane setup Testing Oracle commit latency OS-level view Oracle metrics New log writing behavior internals Summary There will be multiple posts in this series. In this post I will focus on Oracle’s use of Optane Persistent Memory (PMEM) for fast transaction log data flushes (persisting data from redo log buffer to “disk”). There’s more than just the log buffer flush on the critical path of a transaction commit, like messaging and wakeups between the Log Writer and the database connection (foreground) process, I will cover this in the next part. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/posts/testing-oracles-use-of-optane-persistent-memory/

[MaksimIvanovPerm]

wonderful article. thank you very much.