My Oracle Support Banner

When Using the In-Memory Option, Why isn't 100% of a Table Populated in Each Node of a RAC Cluster? (Doc ID 2270941.1)

Last updated on OCTOBER 07, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

The environment is a two node Real Application Cluster (RAC) database running Oracle 12.2.0.1 and utilizing the in-memory feature.

Each node has the same configuration but the tables configured to utilize in-memory are not being populated 100%, however when one database instance is running the same table is shows as being 100% populated in-memory.

You are using the following query to visualize the proportion of each table that is populated in memory:


This document provides additional information to the user on understanding the reason for this and how to achieve 100% population in each database instance.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.