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 |
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
do you know is it possible to run the interface without using oracle apps?
How You Will display the key flexifields in your report
what is the use of format trigger?a
What is a value set? List its various types.
what is the difference between oracle 8i and 9i?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
what is the difference between procedure and function
what are the different calculation columns available in reports?
what is lexical parameter?
The report output is 10 pages then how many times between pages report trigger will fire?