What is the difference between alert log file and trace
file ?
- 1 Answers
- 25861 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 a sub query? Describe its types?
Explain database link?
what is the difference between UNION AND UNIONALL
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How can I combine multiple rows into a comma-delimited list in oracle?
How oracle handles dead locks?
Who i will insert 1 lacks record in a Database table
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
How to create a stored function in oracle?
which language is used to develop the oracle........?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
Oracle General 
