topic Re: Memory not getting refreshed in Application Development and Automation Discussions

Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 10:21:02 GMT

Hi,

I have a small problem.

I have a internal table which store somewhere arnd 20K records and i monitor the memory usage in transaction SM04 which says it arnd 20MB usage.

After deleting 5K records from the internal table the memory should be released and shown in SM04 but it does not happen.

Please suggest how to clear the memory usage also after freeing up some records.

Thanks in advance,

Rajiv Kanoria

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 10:46:42 GMT


 deleting 5K records from the internal table the memory should be released

Depends on, How u r deleting Records? --


CLEAR it_final --> will delete ITAB header line
REFRESH it_final or CLEAR it_final[] --> will delete ITAB body (appended records)
FREE it_final --> will release memory space

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 10:46:59 GMT

Hi ,

IN SM04 You have an option to monitor the memory usage in depth .

Goto 'GOTO' menu and click on memory ... might be there you can get some memory reduced under some session but again getting increased in some other session.

Hope it is helpful.

Regards,

Uma

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:02:58 GMT

I cannot use Free or Refresh as that would delete all the records.I jut want to delete some of them and want to free the memory associated with those records.

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:03:30 GMT

Hi,

I cannot use Free or Refresh as that would delete all the records.I jut want to delete some of them and want to free the memory associated with those records.

Please suggest in reference to this

Regards,

Rajiv Kanoria

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:03:39 GMT

Hi,

I cannot use Free or Refresh as that would delete all the records.I jut want to delete some of them and want to free the memory associated with those records.

Please suggest in reference to this

Regards,

Rajiv Kanoria

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:03:53 GMT

Hi,

I cannot use Free or Refresh as that would delete all the records.I jut want to delete some of them and want to free the memory associated with those records.

Please suggest in reference to this

Regards,

Rajiv Kanoria

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:14:16 GMT

Hi ,

Then do one thing.

eg : main_tab having 1lk records.

delete n number of records from main_tab , copy remaing in other table and free table main_table.

follow the same sequence for next deletion.

Regards,

Uma

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:38:23 GMT

Don't know why you'd be concerned about the memory consumption of 5K records...far better to be sure your program is efficient so that the program is not a resource hog...then you don't have to worry about memory consumption of a mere 20K records...that's miniscule in SAP.

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:50:05 GMT

Hi,

This was just an example....Our record count goes upto 33 Million recordswith upto

500 MB memory usage...

Now what do we do..?

Rajiv

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:51:53 GMT

if possible, use SELECT with package size addition.

Re: Memory not getting refreshed

Former Member — Wed, 09 Jun 2010 11:56:52 GMT

Hi,

Dats cannot be solution as our select queries are proress based.One table is accesed and on the basis of that further queris are decieded .So modifying the Select queries iis totally out of question.I was actually lookig out for some basis paremeter or FM on the basis side which helps me clear this memory

Rajiv Kanoria

Re: Memory not getting refreshed

ThomasZloch — Wed, 09 Jun 2010 12:11:36 GMT

Nothing is out of question by default, if memory consumption is too large, block processing must be investigated.

There is no system parameter for this purpose as far as I know, this question would belong into forum "netweaver administrator".

What you could test is that once you deleted rows from your internal table, memory consumption is not reduced, but it should not go up either when adding entries again until you have consumed more than what was deleted before (like a "peak hold", if you will).

Thomas

P.S. some background information: http://help.sap.com/abapdocu_70/en/ABENMEMORY_CONSUMPTION_1.htm