topic Re: Programname in shared cursor cache in Application Development and Automation Discussions

Programname in shared cursor cache

rainer_hbenthal — Tue, 06 Sep 2011 12:07:05 GMT

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

Re: Programname in shared cursor cache

Sandra_Rossi — Tue, 06 Sep 2011 12:29:16 GMT

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

Re: Programname in shared cursor cache

HermannGahm — Tue, 06 Sep 2011 12:37:01 GMT

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

Re: Programname in shared cursor cache

rainer_hbenthal — Tue, 06 Sep 2011 13:06:37 GMT

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.

Re: Programname in shared cursor cache

HermannGahm — Tue, 06 Sep 2011 13:10:04 GMT

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