Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26932 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 are actual and formal parameters?
How to call a sub procedure?
is there a tool to trace queries, like profiler for sql server?
What is recycle bin in Oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
What is the usage of save points in oracle database?
How to write a query with a full outer join in oracle?
What is system tablespace?
Explain oracle data types with examples?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain the difference between sql and oracle?
what is IDE,DMV in sql server?
Oracle General 
