What process(s) writes to ALERT log file in Oracle? Team:
I have been searching for the process(s) which write to alert log file but couldn't find any reference to the documentation. I believe the background processes write to alert log. Not sure if it's correct. Also, does a server process write to alert log as well? We see a lot of entries in the alert log which states some info is written to trace file abc.trc etc, I was wondering if the particular background process involved with that error write inti that particular trace file.
Any process can write in the alert log.
Even you can write in the alert log using the PL/SQL DBMS_SYSTEM package.
Trace file names clearly indicate which process they belong to. Trace files are named like ORCL_smon_1234.trc, where ORCL is the name of the instance, smon is the name of the server process, 1234 is the OS PID of the process.