How to find expensive SQL statement, if found, what should
be done?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the purpose of support package?
If java is down how you will do trouble shooting?
If you want check java stack level?
WHAT ARE THE STEP BY STEP PROCESS TO APPLY PATCHES ON SAP R/3 SYSTEM?
6 Answers Accenture, Collabera,
How to perform the transport?
Explain Local Client Copy ?
How to add datafile using brtools?what are steps?
How to check cpu usage in EP?
What is the state of Processes once it is started?
How to set predecessor relationship between two transport requests?
If job is slow?
What is difference between oracle 9i and oracle 10g?