How to find expensive SQL statement, if found, what should be done?

How to find expensive SQL statement, if found, what should
be done?

Question Posted / mail2raj.basis

3 Answers
12300 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find expensive SQL statement, if found, what should be done?..

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

Is This Answer Correct ?

5 Yes

0 No

How to find expensive SQL statement, if found, what should be done?..

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

Is This Answer Correct ?

0 Yes

2 No

How to find expensive SQL statement, if found, what should be done?..

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

Is This Answer Correct ?

0 Yes

6 No

Post New Answer

More SAP Basis Interview Questions

how do you solve oracle archive struck?

5 Answers iGate,

List of r/3 user types?

3 Answers

where can i get the Dialog response time?

5 Answers Satyam,

how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?

0 Answers ITC Infotech,

Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

0 Answers

Explain Client Import in SAP?

3 Answers AMA, Cap Gemini,

Error in the phase import_proper while applying support packages?

0 Answers

Tell me steps for support pack installation in ecc6?

1 Answers

What is difference between sm50 and sm66?

4 Answers

How to configure web ui in crm 7.when i am trying to access web ui it gives some error like "Business Server Page (BSP) error What happened? Calling the BSP page was terminated due to an error. SAP Note * The following error text was processed in the system: Die URL enthält keine vollständige Domainangabe (mgpl0001 statt mgpl0001.<domain>.<ext>). Exception Class CX_FQDN Error Name Program CX_FQDN=======================CP Include CX_FQDN=======================CM002 ABAP Class CX_FQDN Method CHECK Line 10 Long text -" what i need to do?.Notify me of follow-up comments via email.my email id is mvraghunatha@gmail.com.Please advice if anybody faced such kind of issue.Could any one help in this regards. It is very urgent. Thanks in advance RAGHUNATH

1 Answers

What is the procedure to disable import all option from stms in sap?

1 Answers

User wants lock ASAP then what will u do?

0 Answers

For more SAP Basis Interview Questions Click Here