How are expensive SQL select statements recognized?
Answers were Sorted based on User's Feedback
Answer / inder09
High database request time caused by many buffer requests on
the database
High database request time as part of the response time
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shanker
Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via
the avg elasp time to get expensive SQL statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / harsh goel
One way of recognizing them is through aerly watch report.
Is This Answer Correct ? | 0 Yes | 0 No |
3. What are Unicode and non Unicode in sap?
What is the relevance of the Deletion Flag/Indicator in the archiving process?
What is the procedure involved in doing a system-copy?
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?
if any errors comming during transport where it will be recodred and how will you rectify? transport log and active log?
How to find out who has deleted a client in the system.
SAP Startup process?
What is V1 and V2?
how do u relese chage request? is it possible to relese change request without relesing task?explain step by step
describe where they would look at the buffer statistics, and what steps they would use to adjust them?
Dear all, I m looking out a Remote Support Service for SAP BASIS opperation, my entire database is within my company only, and we are currently using SAP 4.7, we also looking for upgratation to ECC 6.0. Can any one suggest me who the company is beetr for Upgradation as well as REMOTE BASIS SUPPORT. kindly provide me the PRICE for Remote SAP BASIS SUPPORT SERVICES. Thanks in advance
Can you tell me the path in service market place for download support packs and kernel