01 March 2011

Write your own message into alert log


Run under SYS
begin
  dbms_system.ksdwrt(2, 'Message from DB');
end;

Original
dbms_system.ksdwrt(n, message_string);
where n is:
1 - Write to trace file.
2 - Write to alertlog.
3 - Write to both.

No comments:

Post a Comment