Database In-Memory now supported on Autonomous Database on Dedicated Exadata Infrastructure!

August 23, 2023 | 3 minute read
Andy Rivenes
Product Manager
Jeffrey Cowen
Senior Principal Product Manager
Text Size 100%:

We're excited to announce that Database In-Memory is now available on Autonomous Database on Exadata Cloud@Customer and Dedicated Infrastructure (ADB-D).

Oracle Database In-Memory adds in-memory database functionality to existing databases and transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed workloads. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.

Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity, and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required.

As of Oracle Autonomous Database Dedicated version 19.20.0.1.0, you can enable Database In-Memory if you have 4 or more OCPUs allocated. You can enable between 5 and 70 percent of the available SGA per ADB. Larger numbers of OCPUs will give you even more IM column store space, allowing you to support even larger analytic workloads.

The image below of the Autonomous Data Warehouse (ADW) with RU Version 19.20 shows the new Database In-Memory support. Note under the Resources section the "Database In-Memory area:" line with an "Enable" button next to the in-memory area size:

Clicking on the "Enable" button will bring up the following screen where you can enable Database In-Memory and choose how much memory to allocate to the IM column store.