-- 查询DPC每个节点参数情况
 select dpc.name,
          pln.PARA_NAME,
          pln.PARA_VALUE 
     from SYS.V$DM_INI pln
left join  dpc_bp_raft   dpc
       on sf_get_ep_seqno(pln.rowid) = dpc.raft_id
WHERE pln.PARA_NAME IN (
    'BUFFER'
);


查询内存池增长情况
select SYSDATE(), SES.SESS_ID,
          SES.SQL_TEXT,
          SES.STATE,
          cast(mem.total_size / 1024.0 / 1024 as decimal(10,4)) as used_MB ,
          MEM.NAME,
         bp.name,SES.EID
     from v$sessions ses
left join v$mem_pool mem
       on ses.thrd_id = mem.CREATOR 
left join sys.dpc_bp_raft bp 
		on sf_get_ep_seqno(ses.rowid) = bp.raft_id 
		 where SES.EID=( select eid from SYS.V$SESSIONS where sess_id = '******')
    order by 5 desc;



服务器内存不足
调整HJ BUF GLOBAL SIZE为30000并重启服务器