Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26825 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 pragma autonomous transaction in oracle?
Why do we use bulk collect in oracle?
Is oracle an open source?
How to create additional tablespaces for an new database?
Why do we need integrity constraints in a database?
Explain rename?
How to run the anonymous block again?
What is the data pump import utility?
How to turn on or off recycle bin for the instance?
State some uses of redo log files?
Please explain drop constraint oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to define a variable to match a table column data type?
What is an Oracle Instance?
How to create lov dynamically at runtime & attach to text field?
