What is the difference between alert log file and trace
file ?
- 1 Answers
- 25831 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 |
Define the terms primary key foreign key and also the difference between primary and the unique key
How to create a new table in your schema?
Does facebook use oracle?
Is it possible to enter only time value into a column of a table in sql?
In oracle there is column command, how will you explain that?
What is a proxy class?
Describe the types of sub query?
List out the types of joins.
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
How to create a new user account in oracle?
How can I see all tables in oracle?
How do I know if oracle client is installed on windows?
Oracle General 
