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.

Answer / phani kumar

Trace file contains executions steps of a any event.

Answer / ram

Trace file will have the complete log of a particular
program based on which we can tune the program.

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.

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  

---

what is difference between API and Interface?

2 Answers   Infogain,

---

explain registration steps of a concurrent program.

1 Answers   TCS,

---

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

---

What is SRW Package? (Sql Report Writer)

1 Answers  

---

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

in procedure how to return a value

3 Answers  

---

where u do setup of operating unit?

1 Answers   TCS,

---

explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,

---

why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,

---

What are file in oracle.

0 Answers   BirlaSoft, IBM,

---