How to find expensive SQL statement, if found, what should
be done?
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of table tdevc?
My Apologies, The previous questions were concerning the Transaction ST02
What is a developer key? and how to generate a developer key?
what is netweaver
What is the difference between – support package, kernel and sap note?
What is the difference between st06 and st03?
How u will give new authorizations?
Explain the developer trace?
Explain what is the purpose of tdevc ?
What is the difference between asynchronous and synchronous transport?
i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?
when ever i try to installed sap ecc6.0 sr2 on single system. it show error on phase import abap "Not all objects are successfully processed. DIAGNOSIS: for details see output file with invalid object invalid_objects.txt and log file object_checker.log . SOLUTION: normally it indicate the data load error but in some special cases( for example if some object were created or loaded externally) you can press ok to continue" here error sentence is complete. pls tell what actual error its? is it kernel file related?
what is the difference b/w 4.7EE & ECC5.0?
you want to do a system-copy. List the steps you will take.
What will you do if u got Update failure?