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 Hour Glass state? and how does it be resolved

2 Answers  

---

what is the difference b/w UNIX systems logs and Windows sytem logs?

1 Answers  

---

1.what is the difference between ecc5 and ecc6 ? 2.in workbech request can we import specific clinet only?if 3 or 4 clinets 4.what is the main role domain controler?

1 Answers   HCL, IBM,

---

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

0 Answers  

---

what is the difference b/w repository & data dictionary objects?

3 Answers   Accenture, HCL,

---

Where do you check transport request logs?

0 Answers  

---

1. In which table support pack store....? 2. wht r things happing in back ground during DB backup..?

2 Answers   TCS,

---

1 what errors you faced while applying support package in tcode spam and 2 what is the precaution note that should be read.....while uploading patches

5 Answers   CTS,

---

you have to assign a role to a user.YOu can add the role to user in su01 OR you can add the user to role in pfcg.which method is preferable?why?

6 Answers   Satyam,

---

what is data dictionary objecst?

1 Answers  

---

How do u Monitor and Troubleshoot client copy in SAP?

2 Answers  

---

What is oracle Architecture?

0 Answers  

---