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

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 to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,


how to initialize applications?

2 Answers  


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


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.

3 Answers   Satyam,


Give a brief overview on OrderManagement.

1 Answers   Zensar,






what is the defference between credit memo and debit memo

3 Answers   Wipro,


hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,


After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,


what is the difference between credit memo and debit memo?...

2 Answers   Sony,


Do you know where we can check the status of po?

0 Answers  


can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,


How many schemas we have? how many you have used?

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)