July 16, 2003

How to check for free memory (oracle)


This is a quick one-liner to check for free memory.

SQL> SELECT * FROM V$SGASTAT WHERE NAME = 'free memory';