Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26738 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 |
Explain the use of indexes option in exp command.
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
State the various uses of dbcc command?
what is the syntax of update command?
how to get second highest sal of emp table
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
what are the things that you consider while creating indexes on partitioning tables?
List out the types of joins.
pls explain connect by prior with example and its real time use
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
Explain constraining triggers.
How to loop through data rows in the implicit cursor?
Oracle General 
