-查询数据库占用内存
–查询内存池各个模块占用的内存大小
SELECT T.NAME, T.TOTAL_SIZE/1024/1024 TOTAL_M FROM VMEM_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."VMEM_POOL" A
FULL JOIN SYS.“VTHREADS" 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."VMEM_POOL” A;