What is the difference between alert log file and trace
file ?
- 1 Answers
- 26273 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is save point in oracle database?
Why is oracle used?
What are the different types of modules in oracle forms?
How to get a list of all user accounts in the database?
How do we represent comments in oracle?
How do I manually create a database in oracle?
Explain an index?
How to see the table columns used in an index?
What are the system predefined user roles?
How to shutdown your 10g xe server from command line?
What is ordinary table in oracle?
What are the differences between primary key and unique key?
How to start an oracle instance?
Explain compound trigger in oracle?
What is data block in Oracle?
