Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26713 Views
- I also Faced
- E-Mail Answers
Answer / rutu
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.
| Is This Answer Correct ? | 43 Yes | 6 No |
Why we choose emp number as primarykey?
How to join two tables in a single query using oracle?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
How to load excel data sheet to oracle database
what happened to the global index when I truncate the data in one of the partition?
How to write numeric literals in oracle?
Explain what are the different type of segments?
What is an Integrity Constrains ?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is translate in oracle?
Explain the use of full option in exp command.
How to use group functions in the select clause using oracle?
Oracle General 
