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

1.HOW TO START SDM ? 2.HOW TO APPLY SUPPORT PACKAGES THROUGH JSPM? 3.CAN WE DO UNCAR JAVA SUPPORT PACKAGES IN JSPM? 4.HOW TO MONITOR EP?

1 Answers   Emphasis,

---

How do you extend the table space?

1 Answers  

---

For an ABAP only system, do we have to SSL? What is the pocedure involved in doing a system copy?How to pervent other uses to send mails from SAP?What is SAPS?What is the importance of the clients 000, 001 and o66? How to make security authorization report?What is the information derived from OSS notes?

2 Answers   HCL,

---

Explain the process of Logon Load balancing.

1 Answers  

---

How to change default password of EARLY WATCH STEP BY STEP

1 Answers  

---

How you can disable the ‘import all’ button on stms for the queues?

0 Answers  

---

Explain ECC 6 Installation steps in brief?

4 Answers   IBM, TCS,

---

How do u Monitor and Troubleshoot client copy in SAP?

2 Answers  

---

where can u check the sap errors in windows as the windows system was down.some have windows admin make the system up.where u check the error logs ?how to find the problem is with the os or sap?

1 Answers   Fujitsu,

---

Table space creation

2 Answers  

---

Where will you defind logon balancing, how would define and what strategy will you use?

2 Answers  

---

What is the folder it will ask to install oracle?

0 Answers  

---