Expensive SQL Statements through FM

[Former Member]

HI,

Good day,

As i working on a third party system,

I am looking for a standard Function module which will work similar to ST04

and get all the Expensive SQL statements.,...

Any help would be really Appreciated....

Regards

SAMUEL

[Former Member]

Hello,

ST04 is a complex program. It will be difficult to get a FM for that process. There is a program attached to this transaction "RSDB0004", see if you could use that.

You are looking for FM so that the third party can call it ? If so here is what you can do -

          Create a wrapper FM with some basic parameters and inside this FM call this program.

Best regards,

swanand

[Former Member]

HI swanand Lakka,

Thanks for the reply,

that's really helpful....But can you please suggest me any Standard FM where i can get top SQL Statements.

or

may be working partly as ST04....

Regards

SAM

[Former Member]

Hello,

You could find FM in function group S_ORA_COCKPIT_2. But it will be very difficult for you to use them. SAP has a complex way of doing it, probably you will need to debug ST04 and see how these FM are used. Best of Luck.

best regards,

swanand

[Former Member]

Hi Sam,

Refer SAP Note no.521750

Regards,

Akhil