Hello Everyone,
We have enable Inmemory option in oracle 19c database. We noticed that the GV$INMEMORY_AREA table column (POPULATE_STATUS) showing 'OUT OF MEMORY' status and used_bytes column is taking more than allocated_bytes column. Please guide me, why used_bytes column is taking more than allocated_bytes column.
select INST_ID, POOL, ALLOC_BYTES/1024/1024/1024 ALLOC_GB, USED_BYTES/1024/1024/1024 USED_GB, POPULATE_STATUS from GV$INMEMORY_AREA;
