What is a trace file and how is it created ?
Answers were Sorted based on User's Feedback
Answer / shailendra kumar
Trace file is written by the oracle background process.
there is oracle define the generaly tree types of trace
1. system trace file in generated bdump
2. user trace file in generated udmp
3. cretical trace file or fatal error related trace file
in generated cdump.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the dictionary tables used to monitor a database spaces ?
What are the benefits of distributed options in databases ?
What are the options available to refresh snapshots ?
What is Object Auditing ?
When will the data in the snapshot log be used ?
How to prevent unauthorized use of privileges granted to a Role ?
What is Auditing ?
What are the various type of snapshots ?
What are the database administrators utilities avaliable ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
Differentiate simple and complex, snapshots ?
What is snapshots ?