Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26835 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 data type in oracle?
How to call a stored function in oracle?
What is tns service name?
How to delete a user account in oracle?
When do you get a .pll extension in oracle? Explain its importance
What privilege is needed for a user to create indexes in oracle?
Explain the features of oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What types of joins are used in writing subqueries?
What is primefaces used for?
State all possible different index configurations a table can possibly have?
What is define in oracle?
Please explain oracle data types with examples?
What are the differences between char and nchar in oracle?
How to add a new column to an existing table with a default value?
