My program is running too quickly !

[former_member186444]

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.

[Former Member]

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

[HermannGahm]

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

[christophe_blineau]

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

[Former Member]

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

[Former Member]

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