How to check Oracle database In-Memory space?

Question

I wanted to check the allocated in-memory size of my oracle database. I tried with the query below, but it is not working

SELECT pool,alloc_bytes,used_bytes,populate_status FROM V$INMEMOTY_AREA;

Error- ORA-00942: table or view does not exist

Answer 1

That's because you have a typo in the view name. Instead of the word memory you mistyped memoty.

And here's a proof:

Your query

SQL> 
SQL> SELECT pool,alloc_bytes,used_bytes,populate_status FROM V$INMEMOTY_AREA;
SELECT pool,alloc_bytes,used_bytes,populate_status FROM V$INMEMOTY_AREA
                                                        *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> 

My query

SQL> 
SQL> SELECT pool,alloc_bytes,used_bytes,populate_status FROM V$INMEMORY_AREA;

POOL                                                                           ALLOC_BYTES USED_BYTES POPULATE_STATUS
------------------------------------------------------------------------------ ----------- ---------- ------------------------------------------------------------------------------
1MB POOL                                                                                 0          0 OUT OF MEMORY
64KB POOL                                                                                0          0 OUT OF MEMORY

SQL> 

Enjoy!