how to check if rowid distributed table is fully loaded inmemory (IMDB)
Hi,
I have inmemory_size set in two of the three node rac. when load inmemory table, the v$im_segments shows
INST_ID OWNER | SEGMENT_NAME | SEGSIZEMB | INMEMMB | NOTPOPULATEDMB |
---------- ---------------------------- -------------------- ---------- ---------- --------------
3 scott | EMP | 15042.4922 | 7073.5 | 8147.46094 | |
2 scott | EMP | 15042.4922 | 8415.4375 | 6895.03125 |
How can we confirm that whole of EMP table is loaded inmemory? or if some part of EMP was not loaded into memory due to lack of memory or whatever reason ?