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

wha is the purpose of parameters tab in su01?

5 Answers   IBM,

---

Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

0 Answers   Google,

---

Explain what is luw (logical unit of work)?

0 Answers  

---

Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

0 Answers  

---

what are the pre-requisites to apply support patch?

0 Answers  

---

why do we use cleanipc command before starting the SAP System ?

2 Answers   L&T,

---

How to find sap transaction codes?

2 Answers  

---

Kernel upgradation procedure?

1 Answers  

---

What is osp$ mean?

0 Answers  

---

At OS level in which directory oracle alerts are stored?

1 Answers  

---

For example, my sap system having patch number was 8.I want to apply patch 9 and 10.Mistakenly I will apply the patch directly 11 without applying 9 and 10.How sap system will recognize this problem?

3 Answers   Terrenos,

---

Table space creation

2 Answers  

---