Answer / ravi soma

Tuning in apps to resolve the performance issues (means ot
reduse the time taken by a Query using the Explin Plan and
TK Proof)

Answer / kutti

Tuning is nothing but checking the query performance,suppose you have a query which is taking more time to finish.in that scenario we do performance tuning for that query.

we have to check why and where query is taking more time by using Explain plan in SQL Tools.then we will fix that issue with proper tuning.

Answer / chalam

Tuning in oracle apps is to reduce the time taken by the
query by using the statement Explain Plan

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

what is the difference between procedure and function

3 Answers   Wipro,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

is it possible to run the interface without using oracle apps?

2 Answers   Accenture,

---

Stored procedure?

4 Answers  

---

wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,

---

What is a flexfield? List out its types.

0 Answers  

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

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 GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---