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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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