OracleBrains.Com header image 2

Writing to the alert & trace log

December 30th, 2006 by Rajender Singh · No Comments

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.


Tags: Oracle Administration · Oracle Database

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment