What is the difference between alert log file and trace
file ?
- 1 Answers
- 25881 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 |
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to check the server version in oracle?
Draw E-R diagram for many to many relationship ?
How to write a query with a full outer join in oracle?
Why is oracle so popular?
How to define a cusotmer as a supplier in ORACLE R12
how to store only time in a data base table
What are the built-in functions used for sending Parameters to forms ?
Explain the use of online redo log files in oracle.
Explain joins in oracle?
How to execute a stored procedure in oracle?
What is dynamic proxy?
Oracle General 
