Oracle AI Database 26ai Fast Ingest Enhancements

For more details on Oracle AI Database 26ai please follow this link: https://blogs.oracle.com/database/oracle-announces-oracle-ai-database-26ai.

Memoptimized Rowstore Fast Ingest (Fast Ingest) was introduced in Oracle Database 19c. Fast Ingest enables faster inserts into Oracle Database than traditional inserts or even direct path inserts. As I described in this blog post the intent of the Fast Ingest feature is to support applications that generate lots of informational data that has important value in the aggregate but that doesn’t necessarily require full ACID requirements. Applications like Internet of Things (IoT) where a rapid “fire and forget” type workload makes sense. For example, sensor data, smart meter data or even traffic camera data might be collected and written to the database in high volumes for later analysis.

The Fast Ingest architecture is depicted in the following diagram:

23c Fast Ingest

Fast Ingest Enhancements in Oracle AI Database 26ai

In Oracle AI Database 26ai we have improved memory handling and added support for new features that were not available in 19c. Fast Ingest now supports:
•   LOBs
•   Compression
•   Encryption – tablespace, column and SecureFiles encryption
•   Partitioning – interval, hash and sub-partitions
•   A new MEMOPTIMIZE_WRITE_AREA_SIZE parameter to enable explicit allocation for the memoptimize write area in the Large Pool. The default is still 0 which means the database will determine the size based on memory available.
•   Another new parameter called MEMOPTIMIZE_WRITES which can be set to avoid having to use the MEMOPTIMIZE_WRITE hint.

As you can see, a lot has changed in Oracle AI Database 26ai. Fast Ingest has become easier to use for a much broader set of data formats and database features.

Get Started Today

You can try out the new features of Fast Ingest in Oracle AI Database 26ai. See this demo script for commands to setup and run Fast Ingest and then try out the new features highlighted above.