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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

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