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 type of files are created during the export ?

2 Answers  

---

How to work with Transaction SMLG? How to configure Logon Groups in Application server?

4 Answers   TCS,

---

how do u configure cua?

1 Answers   Cap Gemini, CGI, GSS,

---

Why can't we do it thru some other client?

0 Answers  

---

Screenshot document for solution manager installation.

0 Answers  

---

---

What do you mean by Transport domain?

2 Answers  

---

sap basis training courses @ madiwala bangalore

1 Answers  

---

How do you do the transports?

4 Answers  

---

Explain checkpoint?

0 Answers  

---

What is the difference between st06 and st03?

0 Answers  

---

How to check cpu usage in EP?

0 Answers  

---

What are the question will be asked on SM12(lock entries) and SM13(updates) and SM21 (system logs) transaction activities .

3 Answers  

---