How does oracle write to the alert log?

[bazza]

How does oracle write to the alert log? I belive its one of the standard pl/sql routines, but which one is it, and how do you run it independantly?

Bazza

[jmodic]

You've posted exactly the same question a week ago and you've got your answer then. Don't you read replies of your own threads?

So here we go once again. Oracle does not use any PL/SQL staf for writing into alert log. The facility for writing trace file is built directly into the kernel.

As you might have noticed, Oracle is writing into the alert log even before the database is opened - so if the database is not yet open, how could it use any routine that is stored inside the database?

[bazza]

Apologies, that's me getting my forums mixed. I take your point about when the alertt log is written to.

Please delete this thread, and sorry for any inconveniance caused.

Bazza

[TimHall]

The DBMS_SYSTEM package contains a routine that writes to the alert log. The kernal does not have to call this routine since the kernel can access the file directly, but if you feel the need to do this from PL/SQL you can:

EXEC DBMS_System.ksdwrt(2, 'My Test Alertlog Message');

See:

http://www.oracle-base.com/Articles/8i/DBMS_System.asp

Cheers

[bazza]

Thank you kindly, that was exactly what I was after.

Much appreciated,

Barry