Answer / ananth

Sto4 we can see the Expensive SQL statements with the help
of the Cost
sto4 --- Detail Analysis menu ----Oracle session--- Find
with the help of PID and Explain.

if we Found Expensive SQL statement Analyze those Index's

Answer / pwp

ST03N to see the programs having expensive SQL statements
SM50 to see which table is acessing the program
ST04 to see the exact SQL statement and details
STAD/STAT to see more details

Answer / naveen

Use TCode ST03N.Go to transaction profile and see 0DB Time
and 0 Responce time.
Check the Average sequential Read time by STAT and STAD.
Select the object in Red and

What are the daily activates?

0 Answers  

---

What is Consolidation route and delivery routes? How you will identify them?

1 Answers  

---

What is transport layer and domain controller? In which system you have create domain control?

0 Answers  

---

why do we set Java Path in Environmental Variable.

3 Answers  

---

What is client administration in sap system? Why do we use multiple clients in sap system?

0 Answers  

---

how to check network among Central Instance, Application Server, Database Instance?

2 Answers  

---

Kernel upgrade steps in dual stack and java stack.

3 Answers  

---

What is the production system configuration in sap basis4.7EE?

1 Answers   IBM,

---

hai tell me that which back ground program is run when we using tp param , client copy and back ground jobs schduling, and if any other you know tell me guys?

3 Answers   Satyam,

---

What are patches you applied?

0 Answers  

---

wat description should be given in creating a role....in description area wat should be given ??

1 Answers   IBM,

---

what are the prerequisite for before applying support packs? Shall I apply sap basis patch to all the system, like BW, ABAP, HR, etc.

3 Answers   Terrenos,

---