image

which process write error/message in atert log file ? which process perform rollback ?

Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, while other information is for Oracle Worldwide Support. Trace … continue reading

image

where is oracle’s Alert Log located?

The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions. Oracle will automatically create … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube