一个用来向oracle的alert或者session trace文件写日志的函数

dbms_system.ksdwrt这个函数可以用来向alert file和trace file写日志

PROCEDURE KSDWRT
Argument Name Type In/Out Default?

---

DEST BINARY_INTEGER IN
TST VARCHAR2 IN

dest支持的值为dbms_system.alert_file 和 dbms_system.trace_file

dbms_system.trace_file 对应 1
dbms_system.alert_file 对应 2

SQL> exec dbms_system.ksdwrt(1,‘a message written into trace file’);

PL/SQL procedure successfully completed.

SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name;
/u01/log/main250421/diag/rdbms/cdb1/cdb11/trace/cdb11_ora_357309.trc
SQL> exec dbms_system.ksdwrt(dbms_system.trace_file,‘a message written into dbms_system.trace_file’);

PL/SQL procedure successfully completed.

SQL> exec dbms_system.ksdwrt(dbms_system.alert_file,‘a message written into dbms_system.alert_file’);

PL/SQL procedure successfully completed.

SQL> exec dbms_system.ksdwrt(2,‘a message written into alert file’);

PL/SQL procedure successfully completed.

*** 2025-04-28T16:45:29.114101-04:00 (CDB$ROOT(1))
oracle : a message written into trace file

*** 2025-04-28T16:46:21.448218-04:00 (CDB$ROOT(1))
oracle : a message written into dbms_system.trace_file

2025-04-28T16:46:50.803640-04:00
oracle :
a message written into dbms_system.alert_file

2025-04-28T16:47:14.549799-04:00
oracle :
a message written into alert file