Programname in shared cursor cache

[rainer_hbenthal]

Hi,

i have programnames in the list of the shared cursor names like

AQ90SD==========SD65==========

What kind of programs are those entries? This list is taken from our productive system AP1 client 090. Why do i have AQ1090 in front of it?

This "report!" creats one billion buffer gets, uses 63 million seconds execution time while it was executed only 92 times?

Can someone enlighten me on how to improve this?

//Rainer

[Sandra_Rossi]

Hi,

That's a SAP query in the client area 90 (which corresponds to client 090) -> transaction SQ01

Query name is SD65, and belongs to User group SD. Standard !

Sandra

[HermannGahm]

Hi Rainer,

as Sandra said it is a standard SAP query which is most likely not used properly by the end user.

You have to find out the users running this (use st03, transaction profile, double clicking the "report" shows

the users that ran it) and get in contact with them (how do they use the query, do they put in all relevant filters,

what are they trying to achieve with it and how do they do it and so on...)

Kind regards,

Hermann

[rainer_hbenthal]

Thx for the queicj reply, but i cant find it in st03. Maybe this is occuring only today and will show up tomorrow after the collecter job is done.

[HermannGahm]

Hi Rainer,

in ST03 you can use the "Last minutes load" option as well. In the sql cache in ORACLE you have time stamps (last active time, load time, ...) of the cursor. That might help to find it...

Kind regards,

Hermann