When was the Query executed last time - SQ01

[Former Member]

Hi All,

We have an ECC 6.0 System running on Oracle and os is SUN OS . When i go to TCODE SQ01 i see

many queries. I need to know when were the Queries run on the system. Is there any way to figure

this out.

Any pointers would be helpful

Thanks & Regards,

Ershad Ahmed

[Former Member]

Run Tcode ST04---> SQL statment nalysis--> Table Access

By this u will get complete result.

Thanks

Presu

[markus_doehr2]

Not by default. There are several ways:

- You can use ST03N to find out which queries are executed (select a big timeframe)

- you can enable auditing (SM19/SM20) and track "AQ*" programs

- you can book an SLO service to find the exact number (http://service.sap.com/slo)

Markus