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 are the Import Programs We need to run after creating Interface table for all modules
in one report using two layout models.if yes how to do
what are the sql attributes?
differentiate between intra & inter UOM class conversion with examples.
How to attach the multiple templates in XML Pub Report?
name at least five reports in oracle inventory related to transaction ?
Plz anybody send me Technical specification for AP Interface
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
can we use look up type instead of a pofile option?or valueset?is it possible how?
what type of testing u r doing?
IN WHICH MODULE THE LEGAL ENTITY COMES?
HOW CAN U KNOW TABLE IS REGISTERD IN APPS?