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 item status? name the related table.
What is request group
Plz anybody send me Technical specification for AP Interface
what is aim methodolozy
define steps of assigning items to an organization.
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
Can u define DFF with in the DFF,How?
what is Flex mode and Confine mode?
i have 100 pages output. i want to print 10 records per page in Template?
what is difference between po_headers_all and po_headers
how will you refer a report column (data column,formula,summery,placeholderr)?
What is multi org?