Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26935 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 |
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What is oracle server autotrace in oracle?
How many types of tables are there in oracle?
How to omit columns with default values in insert statement in oracle?
How do we get field detail of a table?
What is blob data type in oracle?
Draw E-R diagram for many to many relationship ?
How to retrieve data from an explicit cursor?
Difference between varchar and varchar2 data types?
From the database level, how can you tell under which time zone a database is operating?
how to find the n'th highest salary from emp ?
What does a Control file Contain ?
Oracle General 
