Automatic In-Memory Now Available In Non-Exadata Environments

June 10, 2021 | 1 minute read
Andy Rivenes
Product Manager
Text Size 100%:

Automatic In-Memory (AIM) was first introduced Oracle Database 18c and has been enhanced in Oracle Database 21c. As a reminder, in the first version of AIM if the size of the objects that have been enabled for in-memory exceed the size of the In-Memory (IM) column store then the least active populated object(s) will be evicted to make room for more frequently accessed in-memory enabled objects. Then in 21c we enhanced AIM with the ability to manage all objects that do not have a pre-existing INMEMORY setting. These objects are automatically set to INMEMORY MEMCOMPRESS AUTO and AIM will then fully manage those objects with the goal of keeping the most active objects populated in the IM column store to provide the fastest performance possible.

The big news is that AIM is now available in non-Exadata environments. There has been a licensing change to allow Database In-Memory customers in all environments, except with the Base Level feature or Oracle Database XE, starting with Oracle Database 19c (19.9) to take advantage of AIM. This means that customers running in non-Exadata environments in the Cloud and on-premises now have the ability to use AIM to automatically manage objects in the IM column store. Check out the licensing guide for Oracle Database 19c and Oracle Database 21c.

Update: In the original post I mistakenly said "in all environments" when AIM is still not available with the Base Level feature or Oracle Database XE. Sorry about the confusion.

 

Andy Rivenes

Product Manager

Andy Rivenes is a Senior Principal Product Manager at Oracle Corporation and is a Product Manager for Database In-Memory. Andy has been working with Oracle products since 1992 and spent a large part of his career managing Oracle databases for both custom and E-Business Suite applications. Andy now spends his time helping customers implement Database In-Memory and providing information about Database In-Memory through blogs, conferences, and customer visits.


Previous Post

First Database In-Memory Summit

Andy Rivenes | 1 min read

Next Post


In-Memory Summit Videos Available

Andy Rivenes | 1 min read