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 |
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
How to make a copied client from the Client 000 cannot be customized?
Wt is the use of logon group? Wt is the meaning of logon group??
What is the minimum work processes needed for a SAP server?
How will determine whether your sap server is unicode or ascii ?
i can also check SAP compliance callibrator in r3p for SOD conflict and simulation tool in addition to id creation , roles assognments , what job i can expect ?
what is the workbench organiser and customizing organiser in transport ?
What is the procedure to applying patches?
How do you configure the TMS?
what post steps and pre steps db refresh
0 Answers vCentric Technologies,
a transport request is imported, it should have finished in 30 min but it is running for one day(it is running in quality system and it has the transport directory local)you see the slog and all logs are showing that import is processing....and it does not show any error...how will you troubleshoot it?
how can we activated profile parameter for disable multiple logon? i have already tried parameter: login/disable_multiple_login_gui=1. but its not affect to sap system. pls give me some step.