Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26934 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
How to invoke the data pump export utility?
What is an oracle?
What is the database name in oracle?
What is a package ? What are the advantages of package ?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is meant by a deadlock situation?
Explain a data segment?
List the various oracle database objects?
What are the extensions used by oracle reports?
How to put more than 1000 values into an oracle in clause?
How to use null as conditions in oracle?
What happens to the current transaction if a ddl statement is executed?
What is query image?
How to drop a stored function?
What privilege is needed for a user to create views in oracle?
