Home » RDBMS Server » Server Administration » Alert log file
Alert log file [message #158742] Tue, 14 February 2006 03:08 Go to next message
ramapoluri
Messages: 3
Registered: February 2006
Junior Member
I knew that the alert log file is a special trace file and which will have all the startup/shutdown,database structure change information and all.....Also,if you delete alter log file and will created automatically with out any effect to the instance.Which process is responsible for this action and what are all the background or some other process which will write information to alter log file?


Re: Alert log file [message #158773 is a reply to message #158742] Tue, 14 February 2006 06:00 Go to previous messageGo to next message
salmansh
Messages: 14
Registered: June 2005
Location: Al-Khobar
Junior Member

The following link should give you more information about your question

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/manproc.htm#1679

then click Monitoring the Processes of an Oracle Instance
under this you will find the passages for Alert trace file.

HTH
Re: Alert log file [message #158774 is a reply to message #158742] Tue, 14 February 2006 06:02 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
There is no special process for it. All background processes can write to the alert.log. In fact, nothing prevents you from writing stuff to it as well:

exec dbms_system.ksdwrt(2, 'Look Ma, I can write to the ALERT.LOG...');
Re: Alert log file [message #158876 is a reply to message #158774] Tue, 14 February 2006 20:41 Go to previous message
ramapoluri
Messages: 3
Registered: February 2006
Junior Member
if you delete alert log file,automatically new file will creates ..so which oracle process will do this monitoring job ?is it got created by any of the background process which is having some information to write in to the alert log file and if that process doesn't find the alert log file will creates new file ?
Previous Topic: 9.2.0.7 Upgrade together with CPU
Next Topic: Reverse Engineering script
Goto Forum:
  


Current Time: Fri Sep 20 15:31:31 CDT 2024