Uncategorized

How to Enable Oracle Database In-Memory

An image of Dual-Format Database.

Oracle Database In-Memory allows you to use a single database for all of your workloads.  That means that Oracle Database In-Memory helps you get the best performance for your transactions while also ensuring that you have real-time reporting and analytics.

Oracle Database In-Memory is a new component of the SGA, or shared global area, thus ensuring that it is integrated fully into your database core.  You do not have to do anything, really.  Once you have the Oracle Database installed, the Oracle Database In-Memory is likewise installed.

During the launch of this product, Oracle announced that the feature is enabled automatically.  And a lot of people thought it meant that all they have to do was to install Oracle Database and the said program would kick in without them having to do anything.

The truth, however, is that Oracle Database In-Memory is not usable by default yet.  Oracle claims that it is a bug that they are working on.  So do not be confused and start working on enabling Oracle Database In-Memory for you to take full advantage of it.

In the meantime, Oracle has provided these helpful steps for you to enable this feature.  Take a look at this page for more information.

Long story short, here are the steps you need to enable Oracle Database In-Memory:

  1. Change the allocated memory of the IM column store to a value greater than 100MB. ALTER SYSTEM SET inmemory_size = 10G scope=spfile;
  1. Change the SGA_Target parameter to a size that would be able to accommodate the new IM column store value you have specified in step 1, plus all the other processes that it needs to take care of.  By default, Oracle puts in “71G” for this parameter, so it would be safe to set your SGA_Target parameter to “71G” plus whatever amount you specified in step 1. ALTER SYSTEM SET sga_target = 81G scope=spfile;
  1. If you are working with a large database, you need to know that you do not need to put your entire database into IM column store.  Instead, you can specify a table, a table space, a partition and other elements that are most important for your database performance.  For example, to enable in-memory for a table named Cornerstone, you would need to use: ALTER TABLE OWNER.cornerstone INMEMORY;

Oracle Database In-Memory typically puts your table into the in-memory column when you first access it.  Or it does so on demand.  To check if you have successfully enabled in-memory for your Cornerstone table, run a query on the table after you access it.  Take a look at the v$IM_SEGMENTS, and you should be able to see that your table has a COMPLETED status.  Then you should take a look at the feature tracking information and confirm that the feature is now enabled AND used.

Conversely, you can use the NO INMEMORY attribute to get the table out of the IM column store.

ALTER TABLE OWNER.cornerstone NO INMEMORY;

Need help enabling and using Oracle Database In-Memory?  Call Four Cornerstone today!

Photo by Oracle.

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Live Chat | Emergency