Recently I came to know about very interesting procedure called “KSDWRT” in DBMA_SYSTEM.
It can be used to add our own custom entries to the alert log or trace file or both depending on the first parameter that we pass to this procedure.
DBMS_SYSTEM.KSDWRT(1,’Testing Writting to Trace File’);
DBMS_SYSTEM.KSDWRT(2,’Testing Writting to Alert File’);
DBMS_SYSTEM.KSDWRT(3,’Testing Writting to Trace & Alter File’);
Use 1 to write to the trace file
Use 2 to write to the alter file
Use 3 to write to both.
0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment