Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why USED_BYTES are more than Allocated_bytes in V$INMEMORY_AREA view?

user12180635Jul 23 2024

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.

Comments
Post Details