查询Oracle内存使用情况

SELECT * FROM V$MEMORY_RESIZE_OPS;

SELECT * FROM V$SGA_DYNAMIC_COMPONENTS WHERE name='buffer_cache';


SELECT * FROM v$sgnfo;

# 不确定是否准确
SELECT sum(value)/(1024*1024*1024*1024) 
FROM v$pgastat