what is trace file? what is the use of that?
Answers were Sorted based on User's Feedback
Answer / uday
trace file is a log of SQL run in a particular session or
sesesions
focused on selects, inserts, updates, and deletes.
A trace file can be used in many circumstances including
reviewing performance,
finding tables and views referenced, or finding the root of
an error.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / phani kumar
Trace file contains executions steps of a any event.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ram
Trace file will have the complete log of a particular
program based on which we can tune the program.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhi
The main use of enabling trace for a concurrent program comes during performance tuning.
By examining a trace file, we come to know which query/queries is/are taking longest time to execute.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is trace file? what is the use of that?
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
How You Will display the key flexifields in your report
what is the back ground program run while transferring data from OM to AR?
What r the validation done in ap inbound ?
Difference between Bind and Lexical parameters?
How to insert data into two tables using single control file?
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
what is the error you will get if field is referenced in wrong repeating frame?
What r the validation types?
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
AOL?