What is a trace file and how is it created?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

216. What is a trace file and how is it created?

Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

(Continued on next question...)

Other Job Interview Questions

• What are the different default triggers created when Master Deletes Property is set to Non-isolated?
• What is a DBA?
• What is the mechanism provided by ORACLE for table replication?
• What are the database administrators utilities available?
• What is the fastest query method for a table?
• How is it possible to select generate a select set for the query in the query property sheet?
• Compare and contrast TRUNCATE and DELETE for a table.
• If you have an example table, what is the best way to get sizing data for the production table implementation?
• How can we reduce the network traffic?
• How can you tell if a tablespace has excessive fragmentation?
• More...