Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26714 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
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is key preserved table?
Can you drop an index associated with a unique or primary key constraint?
How to initialize variables with default values?
what is reindexing?
What are the system predefined user roles?
What is a cursor in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
Explain the different normalization forms?
Explain what are the characteristics of data files?
What is varray?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to get a list of all user accounts in the database?
What is a parameter file in oracle?
How to rename a column in an existing table?
