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 multi org tables . example - difference between app table non all table . Po_header and po_headers_all
Difference between set of books id and ledger id in r12 ?
where to define interorganization transaction charges and what are the different options?
What is count(*) from po_vendors(any table)?
in ap_terms table what data will be stored
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
WHAT IS REFCURSOR IN ORACLE ?
Explain what are the tables of auto invoice?
difference between 2 way and 4 way matching
Where I can download D2K software?
what are the different transaction clauses in AR?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?