Expensive SQL Statements of the day?

[pr_srinivas]

Hi...

How can i find out Expensive SQL Statements of the day please.?

Our SAP Version is ECC 6.0 on Oracle 10.2.0.4.0

Rgds

[Former Member · Accepted solution]

Go to ST04 --> Expand SQL Statement analysis --> Shared Cursor cache.

also Read: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c4/3a7230505211d189550000e829fbbd/frameset.htm

[fidel_vales]

If you only want the expensive statements for one specific day (or hour) then you can use AWR.

You can generate the AWR report for the specific day/time using the script awrrpt

In order to use AWR you need to have licence the Oracle Tuning Pack and the Oracle Diagnostics Pack. See SAP Note

740897 for info about this licences.

[ashish_vikas]

Hello Srinivas,

For finding expensive SQL for any specific day

1. First try to find expensive backgroung job report/ tcode for that day. This you can check from ST03N(sorted with total DB time for that day).

2. Now check SQLs which are expensive for this report as mentioned above.

thanks

ashish

[Former Member]

Hi Srinivas,

On ECC 6.0, go to ST04 t-code --> performance --> SQL Cache --> You see SQL Statements where you need to sort by SQL Statements by Total Execution Time(ms).

I have tried on one of my R/3 4.7EE system, ST04n --> Resource COnsumption --> Top SQL Statements --> you will see 50 Top most expensive SQL Statements interms of wait time.

also Read: [;

[;

Regards,

Kanthi Kiran