Hi 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;
INST_ID POOL ALLOC_BYTES USED_BYTES POPULATE_STATUS
1 1MB POOL 20.98046875 1555.04637078103 OUT OF MEMORY
1 64KB POOL 8.97955322265625 1275.824841314 OUT OF MEMORY
Thank you.