How do you clear the temporary memory of SAP?

[mtremblay-savard]

Hello Master,

My question here is how can i clear the temporary memory of SAP? My problem is that i am trying to do some performance tests, but SAP remembers some info from the first try so the second time i start my program, it takes 10 times less time... So this is not very helpful to make an idea if i've optimized my program or if SAP simply remembered my first processing.

From what i have been told, SAP would keep some kind of temporary memory of the database requests and i want to clear this, in fact, i want to clear anything that could make my program go faster on the second processing!

Take you everyone!

Best regards,

Max.

[Former Member · Accepted solution]

There is no way you can clear all involved buffers without shutting down the server since there are buffers in the database level, operating system level. If you are worried only about SAP buffers, enter /$sync in the code field to flush all SAP buffers and /$tab to flush only SAP table buffers. It also helps to logoff the system, that way your SAP session gets flushed. See the attached link for details.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/c4/3a6f8f505211d189550000e829fbbd/frameset.htm

[Former Member]

In addition to Samuli Kaski reply: you can flush buffers at db level. For example, for oracle you can use alter system flush buffer_cache, alter system flush shared pool commands. The same commands exists for other DBMS too. In properly configured system operating system cache does not used for db purposes so you can ignore it.

Regards,

Roman