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 |
Oder of firing triggers in form
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
The report output is 10 pages then how many times between pages report trigger will fire?
In xml report, how to print the headings in every page?
How can u find custom top? where its located? How to find custom top in front end?
What is SRW Package? (Sql Report Writer)
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
Can we create tables in apps schema?
where we can check the status of po.
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
what is aim methodolozy