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.

how many printers are there in the land scape

1 Answers   L&T,

---

What is sap ides?

0 Answers  

---

How to lock or unlock a client a sap?

2 Answers  

---

What do you mean by Consolidation routes?

3 Answers  

---

Hi there, Can any one suggest me a good SAP-BASIS training institute near Indiranagar In Bangalore.

6 Answers  

---

Hi Al I have a small querry in SAP there are different type of Users one of them is System User I want to know why the system user is created and if created what is use of them and how they are associated with the Dialogue User ,As we all know Dialogue user can perform all work in Sap by logging in the sap server , so why the system user is created and how they are associated with Dialogue user With Rgds

8 Answers  

---

Can we run CIC Webclient without installing Web Application Server? If Yes, then what are the basic settings which we have to do to run webclient. If No, then is it possible to install Web AS on the same server where our SAP CRM is installed?

2 Answers   Infosys,

---

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

14 Answers  

---

How to import the OSS notes?

3 Answers   IBM,

---

If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log

0 Answers  

---

What are the parameter file in oracle ? What is the use?

1 Answers  

---

Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com

0 Answers  

---