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 is ERP?

10 Answers  

---

Where to check for system logs of Sap application at os level?

10 Answers   Satyam,

---

What are common transport errors?

6 Answers   Accenture, IBM,

---

What is Data Dictionary ?

2 Answers  

---

How do you handle the lock entries?

4 Answers  

---

---

Explain what is “data sets” in sap?

0 Answers  

---

What will you do when spool process fails?

2 Answers  

---

How do you solve oracle archive struck?

0 Answers  

---

HOW MUCH RATED YOUR SELF IN "BASIS" ? IS IT INTERVIEW QUESTION? WHY INTERVIEWERS ARE ASKING THESE TYPE OF QUESTIONS INSTEAD OF ASKING TECHNICAL QUESTIONS IN TECHNICAL ROUND ?

1 Answers   Wipro,

---

what are activities u will do when long running bkg jobs?

3 Answers   Patni,

---

35.If you see the same parameter value in all instance profiles what will you do ?

2 Answers   Cap Gemini,

---

After Installation of the SAP software, its giving posting period 2004. I am not able to make it to 2009 financial year.. how we make it.. what are the activities we have to do ?

1 Answers  

---