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

what is aim methodolozy

1 Answers  


What is request group

4 Answers   Accenture,


PL/SQL stored procedure parameters?

7 Answers  


What do you understand by soa?

0 Answers  


Can u define DFF with in the DFF,How?

1 Answers   Satyam,






Which is the best website to learn Oracle Apps?

2 Answers  


1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,


what is the use of placeholer column?

3 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  


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,


What r the validation done in ap inbound ?

2 Answers   Questam,


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)