Interested to Buy Any Domain ? << Click Here >> for more details...
What is a trace file and how is it created ?
- 2 Answers
- 3961 Views
- I also Faced
- E-Mail Answers
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 is the use of ANALYZE command ?
What are the system resources that can be controlled through Profile ?
How will you enforce security using stored procedures ?
What is a profile ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
How can you Enforce Refrencial Integrity in snapshots ?
what is meant by physical order and logical order in clustered index and non clustered index.
What are the use of Roles ?
What is Privilege Auditing ?
What is snapshots ?
What are roles ? How can we implement roles ?
How to prevent unauthorized use of privileges granted to a Role ?
Oracle General 
