Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26847 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 null value?
What is a nested table?
can we insert any row to dual table if i got the permission from DBA
what is the dual table in oracle?
What is an oracle wallet?
What is ASM (Automatic Storage Management) in Oracle?
How to generate query output in html format?
What is recovery manager(rman) backup in Oracle?
Can we create more than one constraint to column ?
How to start instance with a minimal initialization parameter file?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What is not equal to in oracle?
Oracle General 
