Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not all data is in memory on an in memory table

edited Apr 15, 2021 12:45AM in Database 1 comment

Summary

How to get 100% of content into an in memory table

Content

I have a table WC_LEAVE_LIAB_F defined as In memory

 

I believe it was 100% in memory as graphs were generated quickly

 

I applied the BTREE index on SNAPSHOT_DT and the table queries now return quickly, however the performance of the chart has dropped

 

Looking at the inmemory stats on V$IM_SEGMENTS  there is a large amount of data reported as BYTES_NOT_POPULATED so guessing some data has been knocked out of memory since the index creation.

 

How can I get this data back in memory?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!