March 2017

Finding what tables are in INMEMORY

Since INMEMORY allows the INEMOMERY and its compression settings to be at the column level, when looking at what we have INMEMORY, besides v$im_segments, we need to also look at V_$IM_COLUMN_LEVEL. When checking for INMEMORY, I look at:   dba_tables – Is the table configured for INMEMORY. v$im_segments – Has the table actually been loaded into […]

Read more →