what is trace file? what is the use of that?

Question Posted / chandrasekhar.bs

4 Answers
8561 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is trace file? what is the use of that?..

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

what is trace file? what is the use of that?..

Answer / phani kumar

Trace file contains executions steps of a any event.

Is This Answer Correct ?

5 Yes

0 No

what is trace file? what is the use of that?..

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

what is trace file? what is the use of that?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers TCS,

What is set function in sql .E.g.What is difference between union and union all

2 Answers IBM, TCS,

types of invoices?

7 Answers BelAir Store, Convergys, Wings Biotech,

What do you understand by concurrent programs?

0 Answers

what is the need of registering table in apps?

5 Answers TCS,

What does appl_top directory contain?

0 Answers

what is the data type of lexical parameter?

5 Answers Wipro,

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

0 Answers

How to send the e-mail notification in XML Pub Report?

2 Answers Accenture, Oracle,

How will you get the concurrent program output as email?

3 Answers IBM, KPIT,

we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?

1 Answers

What is the link between AP and GL in oracle apps R/12?

4 Answers Bosch, Collabera, Synechron,

For more Oracle Apps Technical Interview Questions Click Here