:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Databases >> Oracle >> Oracle General


 Oracle General interview questions  Oracle General Interview Questions (719)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (265)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (181)
What is the difference between alert log file and trace 
file ?
 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
# 1
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 ?    23 Yes 3 No

Other Oracle General Interview Questions
  Question Asked @ Answers
What is the use of Redo Log Information ?   2
can u call user defined functions in select statements   2
What are the type of Synonyms?   1
what is data independence exactly? give an example   5
Differnce between view and index   2
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!   1
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview) Infosys 4
can we pass two out parameters at a time in function?please answer to my question Wipro 3
what is index?   4
how to delete all duplicate records from a table using subquery? Cap-Gemini 6
What are the trigger associated with image items ? Oracle 1
What is Trace File ? Thermotech 4
For more Oracle General Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::