达梦数据库并发场景下,抓取执行久/等待久的慢SQL
-- ss单位是秒
select*from(select(SELECTround(SUM(TOTAL_SIZE/1024/1024), 2)FROMV$MEM_POOL CwhereC.name VIRTUAL MACHINEAND C.CREATOR A.THRD_IDGROUP BYCREATOR)AS VM_TOTAL_SIZE_BY_M,a.trx_id ,last_recv_time,a.thrd_id ,clnt_ip …
2026/8/13 17:53:03