Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between alert log file and trace
file ?
- 1 Answers
- 26838 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 |
What happens if you set the sga too low in oracle?
what are steps for interface? where is exchange rate defined in which table?
am completed mca2011 how get certification in oracle
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What is oracle used for?
What are the parameters that we can pass through a stored procedure?
How to use "while" statements in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
hai, when to use char and varchar2....?
What is a table index?
DBMS vs. RDBMS
What are the factors causing the reparsing of SQL statements in SGA?
Oracle General 
