What is the difference between alert log file and trace
file ?
- 1 Answers
- 26259 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 |
What is blob datatype?
What does sharding mean?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Where do we use decode and case statements?
What is the difference between a hot backup and a cold backup in oracle?
What are the most common interview questions on ETL Testing for experience?
What is the quickest way to export a table to a flat file?
How to display row numbers with the records?
What is oracle server autotrace in oracle?
How to use in conditions in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to export your connection information to a file?
Oracle General 
