answersLogoWhite

0

Alert log file is found at the background dump directory specified by the background_dump_dest parameter. Alert log file logs the information like startup or shutdown information of the database,admin activities and its all done by the server process. Example suppose you are away from monitoring database and database stop running or shutdown or restarted the information and the ora error messages will be checked by the alertlog file. Trace file is found at the user dump directory specified by the user_dump_dest parameter. Trace file logs the information about user activities or the information about any internal error occurs at the database and its a user process.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are the different types of physical files in the Oracle 9i?

* Database datafiles - contain the data itself * Control files - binary files containing information about the database (name, files, backup...) * Online redo logs - files, which record every transaction in the database * Parameter files - database parameter file * Other database related files - password files, alert log, trace files...


What are trace files in NS2?

when we compile tcl script then two files are created i.e. NAM file and Trace file. NAM file are those to display the animation area and trace file are those where we can analyse our data. with regards anchal kumawat


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 was released on: USA: 2 June 2004


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004 Salisbury 1-5?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 Salisbury 1-5 was released on: USA: 30 June 2004


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004 2005-01-01?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 2005-01-01 was released on: USA: 1 January 2005


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004 Trumball 1-6?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 Trumball 1-6 was released on: USA: 7 July 2004


Is there a fax machine that you can send a fax out and not receive a confirmation?

Traditional old fax machine don't have any message confirmation. Modern fax machine have sent log files which you can trace the failed and success sending of fax. Internet fax services have alert message of received and sent faxes to your mobile phones.


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004 Warwick Dover 1-4?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 Warwick Dover 1-4 was released on: USA: 23 June 2004


What are the release dates for Trace Evidence The Case Files of Dr- Henry Lee - 2004 New Orleans 1-3?

Trace Evidence The Case Files of Dr- Henry Lee - 2004 New Orleans 1-3 was released on: USA: 16 June 2004


Can I download files from a shared network to a thumb drive without leaving a trace on my hard drive?

Downloaded files always make a temp file in your computer, no matter you delete it or not there is always a way to recover it. So you can not download and copy files from a system without leaving a trace.


What is the process used to encode files to trace and detect copyright violations?

Digital watermarks, also known as "fingerprinting."


What tool do you use to trace the relationship between the formulas in the cells of a worksheet?

You use the auditing tools, which include the trace precedents and trace dependents commands.