topic Re: My program is running too quickly ! in Application Development and Automation Discussions

My program is running too quickly !

former_member186444 — Fri, 30 Jan 2009 09:18:09 GMT

I have an unusual problem with a program that has some performance problems in our Quality system. When I run it the first time, it takes 13 minutes. If I run it again (with the same parameters), it then runs in less than one minute. None of the tables in question are buffered at SAP level (so BYPASSING BUFFER wouldn't have any effect), so I'm guessing that there is some buffering in Oracle that is doing this. Our Basis guys have cleared out the buffers in Oracle for me but this does not seem to make a difference and the program keeps running in less than one minute.

This is a bit frustrating as I can't analyse the problem as well if I can't run a tool against it when it's taking longer to execute.

Any ideas ?

thanks,

Malcolm.

Re: My program is running too quickly !

Former Member — Fri, 30 Jan 2009 10:41:33 GMT

Whenever you execute any program, a temporary buffer creates on. This is something like LUW Concept in SAP. I dont think this can be Changed by any Basis Settings... Try to come out of SAP after execting and then Execute the Prog again you can feel the Difference..

Thanks

Rajesh

Re: My program is running too quickly !

HermannGahm — Fri, 30 Jan 2009 10:56:55 GMT

Hi Malmcom,

this sounds indeed like some caching on DB or lower levels (FS cache, or storage cache).

To analyze this furterh you can run a specific (native) select in the SQL command

editor (in ST04) as a job. With the "print runtime data" option you'll get the session statistics.

These tell you exactly how much logical i/o (cache) and physical i/o (could be cached

as well in FS cache or storage box cache) you did and how long these took.

This is the analysis part. The "solution" or "tuning" is a different story then.

Kind regards,

Hermann

Re: My program is running too quickly !

christophe_blineau — Fri, 30 Jan 2009 12:32:32 GMT

Hello,

Well as your problem occurs in Quality system, you may be able to stop SAP instance and Oracle.

And after restarting use standard tools to log runtilme and database access.

Nevertheless are you sure that your problem come from this program, It may also occurs when an overload occurs on server and this is quite difficult to reproduce ;-).

Sincerely

Christophe Blineau

Re: My program is running too quickly !

Former Member — Fri, 30 Jan 2009 12:40:37 GMT

Take a look in transaction SU21 at the authorization object documentation for S_ADMI_FCD where the admin function is "TOUC".

That is what you appear to be looking for, but don't do it in a production system...

Cheers,

Julius

Re: My program is running too quickly !

Former Member — Fri, 30 Jan 2009 13:35:38 GMT

Are you sure it is the database? Have you profiled with SE30? What does your SQL look like?