Alert log file [message #158742] |
Tue, 14 February 2006 03:08 |
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 #158774 is a reply to message #158742] |
Tue, 14 February 2006 06:02 |
Frank Naude
Messages: 4587 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 |
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 ?
|
|
|