Skip to Main Content
  • Questions
  • View To See When Last In Memory Repopulate Was Done On A Table?

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Connor McDonald

Thanks for the question, Sunny.

Asked: June 18, 2020 - 6:24 am UTC

Last updated: June 19, 2020 - 5:59 am UTC

Version: 19.1

Viewed 1000+ times

You Asked

Hello,

I could not find the answer in the archives and I've been searching/reading docs to no avail. Totally new to In Memory and learning as I go a long.

We have some tables that are repopulate IN MEMORY using DBMS_INMEMORY.REPOPULATE and this is done via a scheduled DBMS JOB. However, I have reports (APEX) based on these IM tables whereby I need to let the user know how old the data is (or when it was last refreshed).

Q. Is there a view that let's me know when a table was last populated/repopulated?

Thanks in advance,

Sunny Patel.

and Connor said...

I want to clarify something - the in-memory area is not a "snapshot" of the data, so it will never be "stale" or "out of date".... So there is never a need to issue a populate command unless you have either

a) modified the inmemory attributes of the table (eg added a column etc)
b) want to populate data manually (eg after a restart)

So the data is never "old". It is always up to date. That is one of the very cool things with in-memory compared to what you see in other databases.

Anyway, check out V$IM_SEGMENTS_DETAIL as well for metadata about the in-memory store.

We're not taking comments currently, so please try again later if you want to add a comment.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database