Answer / inder09

Using ST03N Choose the Standard Transaction Profile in
transaction ST03N and restrict the display to task type Dialog.
Sort the Average DB time (ms) column in descending order.
Transactions with high average DB request times might be
caused by expensive SQL statements.

Sort the Total Database Time column in ascending order. Then
Total this column. Transactions causing more than 5% of this
total database time are worth a closer look with respect to
tuning measures.

Sort the Total Response Time column in ascending order. Then
Total this column. Transactions causing more than 5% of this
total response time are worth a closer look with respect to
tuning measures.

Using the Database Monitor ST04
The quality of the database data buffer should be higher
than 90%.

Check the number of user calls compared to recursive calls.
There should be less recursive calls than user calls.

Check the Reads/User Call. If this value exceeds 30(blocks
read per user call) then this is a strong indicator for
expensive SQL statements

Answer / venkat

To find expensive sql statement.

Goto DBACOCKPIT ->performance->SQL statement Analysis->shared cursor cache [sap net weaver]
Goto ST04 -> Detailed Analysis Menu -> SQl Request -> Sort by disk reads/ buffer gets / executions.

goto ST05 and find out the sql statements whic consumes more than are around 50000 records are reads.

you have to work with DBA people to finetune them

Answer / rout

U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.

IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE ARUN FROM SD

1 Answers   Wipro,

---

How to find sap transaction codes?

2 Answers  

---

How does SAP connect to Db?

2 Answers  

---

What does mean by SWAP? Where should we monitor this? what is the threshold value for swaps/day? If it is more what will u do?

3 Answers   Wipro,

---

What is IDES?

12 Answers  

---

---

how to backup redolog files&log files

3 Answers   Tresbu,

---

how do you solve oracle archive struck?

5 Answers   iGate,

---

When will the table get automatically updated in the database IN ABAP? a) activating the table b) saving the table

2 Answers   IBM,

---

In an SAP system, while using the Transaction DB02 there are Swaps figures that are RED, How can one solve this problem....

4 Answers  

---

where i can find the file sapinfo.exe (to check the sap server is running or not through cmd "sapinfo.exe"). i have already check all the SAP GUI installation DVD and sap installation folder, please help, thanks in advance

1 Answers   Accenture,

---

How u will assign Logon Groups?where u find logo.ini

2 Answers   Infosys,

---

what type of files are created during the export?

6 Answers   Accenture,

---