We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Question
5
Views
0
Comments
edited Apr 15, 2021 12:45AM in Database

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!