Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26731 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 |
Can we store pictures in the database and if so, how it can be done?
How to write a query with a right outer join in oracle?
How to use "out" parameter properly?
what is candidate key & super key
What is the difference between postgresql and oracle?
How to use subqueries with the in operator using oracle?
What is the difference between a hot backup and a cold backup in oracle?
What are the commands youd issue to show the explain plan for select
various types of joins
How to get last row id?
What is the difference between a user and a schema in oracle?
What are advantages of dateset in datastage?
Oracle General 
