1. 配置sqllog.ini
   具体配置内容可参考https://eco.dameng.com/document/dm/zh-cn/pm/physical-storage

BUF_TOTAL_SIZE          = 10240         # SQLs Log Buffer Total Size(K)(1024~1024000)
BUF_SIZE                = 1024          # SQLs Log Buffer Size(K)(50~409600)
BUF_KEEP_CNT            = 6             # SQLs Log buffer keeped count(1~100)

[SLOG_ALL]
FILE_PATH    = ../log
PART_STOR    = 0
SWITCH_MODE  = 2
SWITCH_LIMIT   = 128
ASYNC_FLUSH   = 1
FILE_NUM = 5
ITEMS    = 0
SQL_TRACE_MASK  = 1
MIN_EXEC_TIME = 0
USER_MODE   = 0
USERS =
EXECTIME_PREC_FLAG = 0


[MODE_A]
FILE_PATH    = ../log/mode_a
PART_STOR    = 0
SWITCH_MODE  = 2
SWITCH_LIMIT   = 128
ASYNC_FLUSH   = 1
FILE_NUM = 5
ITEMS    = 0 
SQL_TRACE_MASK  = 1
MIN_EXEC_TIME = 0 
USER_MODE   = 1 
USERS = UserA1:UserA2

[MODE_B]
FILE_PATH    = ../log/mode_b
PART_STOR    = 0
SWITCH_MODE  = 2
SWITCH_LIMIT   = 128
ASYNC_FLUSH   = 1
FILE_NUM = 5
ITEMS    = 0 
SQL_TRACE_MASK  = 1
MIN_EXEC_TIME = 0 
USER_MODE   = 1 
USERS = UserB1:UserB2

2. 动态刷新sqllog.ini配置

./disql
-- 设置 SVR_LOG 为 1，启用 SQL 日志
SQL> SET OPTION SVR_LOG=1;

-- 刷新 SQL 日志配置
SQL> CALL SP_REFRESH_SVR_LOG_CONFIG();
-- 查询 sqllog.ini 文件中的配置
SQL> SELECT * FROM V$DM_SQLLOG_INI;

3. 动态修改dm.ini中的sql配置

-- 设置 SVR_LOG_NAME 为 MODE_A 和 MODE_B，启用这两个模式
SQL> CALL SP_SET_PARA_STRING_VALUE(1, 'SVR_LOG_NAME', 'SLOG_ALL,MODE_A,MODE_B');
-- 查询内存中的 SQL 日志配置
SQL> SELECT * FROM V$DM_SQLLOG_CONFIG;

4. 测试

SQL> CREATE USER UserA1 IDENTIFIED BY "Dameng123";
SQL> CREATE USER UserA2 IDENTIFIED BY "Dameng123";
SQL> CREATE USER UserB1 IDENTIFIED BY "Dameng123";
SQL> CREATE USER UserB2 IDENTIFIED BY "Dameng123";

mode_a文件夹下：只含有UserA1和UserA2的记录

mode_b文件夹下：只含有UserB1和UserB2的记录

log文件夹下：包含所有记录