How to find expensive SQL statement, if found, what should
be done?
Answer Posted / 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 View All Answers
What is transport layer and domain controller? In which system you have create domain control?
What is MySAP?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
How you can assign an object to 100 roles at time?
How do you check the users logs in your system and how many sessions each user is generating?
How u will give new authorizations?
how can i change access to a user who is having access for SPRO display only to change access in sPro
How you can disable the ‘import all’ button on stms for the queues?
What do you understand by sap client administration?
How many types of work processes are there in sap ?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
How you will give new authorizations?
I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?
Have u applied patches what is the transaction code?
How many types of work processes?