1.部署达梦企业管理器DEM进行监控，详见
https://eco.dameng.com/document/dm/zh-cn/ops/tool-monitor

2.通过定时作业定时把v$sessions的查询结果插入一张表

CREATE TABLE T_SESSIONS(
USER_NAME varchar(200),
CLNT_IP varchar(200),
CLNT_VER varchar(200),
dt varchar(200)
)

call SP_CREATE_JOB('JOB_SESSIONS',1,0,'',0,0,'',0,'');

call SP_CREATE_JOB('JOB_SESSIONS',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('JOB_SESSIONS');

call SP_ADD_JOB_STEP('JOB_SESSIONS', 'STEP_SESSIONS', 0, 'insert into T_SESSIONS SELECT user_name,clnt_ip,clnt_ver,SYSDATE from v$sessions;', 1, 2, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('JOB_SESSIONS', 'SCHEDULE_SESSIONS', 1, 1, 1, 0, 1, '00:00:00', '23:59:59', '2021-10-11 11:14:17', NULL, '');

call SP_JOB_CONFIG_COMMIT('JOB_SESSIONS');

SELECT * from V$SESSION_HISTORY