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

peter.hrasko.sk · Accepted Answer · 2015-06-24 13:55:06Z

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!

edited Jun 24, 2015 at 13:55

answered Jun 24, 2015 at 8:13

peter.hrasko.sk

4,2012 gold badges21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dinidu Hewage Over a year ago

your answer does not give any value to me. you have typed the same query again instead of giving a correct one.

peter.hrasko.sk Over a year ago

@Dinidu, are you sure? :-) You have "v$inmemoTy_area" in your query, whereas I have "v$inmemoRy_area" in my query. (Please note the bold uppercase letters in this comment.) Read my answer once again and more thoroughly.

Collectives™ on Stack Overflow

How to check Oracle database In-Memory space?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related