Utilizing Memoptimized Rowstore in non-Exadata Database Environments.
This blog post by Andy Rivenes Product Manager highlights the fact that Memoptimized Rowstore is Available in non-Exadata Database Environments.
Here is a brief summary.
- Memoptimized Rowstore was first introduced in Oracle Database 18c.
- Memoptimized Rowstore is made up of two components: Fast Lookup and Fast Ingest.
- These new features at the time were for Exadata On-Prem and Cloud environments only; However, they are now available in non-Exadata environments in 21c and in 19c starting with the 19.12 RU.
- The Memoptimized Rowstore Fast Ingest feature enables fast data inserts into Oracle Database: This enables support for applications that generate lots of informational data that has important value in the aggregate but that don't require full ACID requirements e.g. Internet of Things (IoT) Apps with rapid "fire and forget" type workloads.
- Memoptimized Rowstore Fast Lookup feature supports SELECT queries on primary key values: This Very Fast Lookup feature can be helpful for applications that require very high-frequency reads.
Enjoy this blog post highlighting this very useful capability.
Cheers.