–查询内存池各个模块占用的内存大小
SELECT T.NAME, T.TOTAL_SIZE/1024/1024 TOTAL_M FROM V$MEM_POOL T ORDER BY TOTAL_M DESC;

–查询各个线程占用的内存大小
SELECT B.NAME, B.ID, A.CREATOR,A.NAME, A.ORG_SIZE, A.TOTAL_SIZE/1024/1024 TOTAL_SIZE_M,A.N_EXTEND_EXCLUSIVE, A.N_EXTEND_NORMAL
FROM SYS.“V$MEM_POOL" A FULL JOIN SYS."V$THREADS” B ON A.CREATOR = B.ID AND B.NAME = ‘DM_SQL_THD’
ORDER BY A.TOTAL_SIZE DESC NULLS LAST ;

–查询内存池使用情况
SELECT SUM(A.TOTAL_SIZE)/1024/1024 TOTAL_M,SUM(A.DATA_SIZE)/1024/1024 DATA_SIZE_M from SYS.“V$MEM_POOL” A;