Poor performance loading LiveCache

[Former Member]

Dear Experts,

We are using APO DP for about 450.000 CVC's with about 24 Mio records in LiveCache. When I check memory usage in live cache (LC10), only 25% of LC memory is occupied by this amount of data.

My problem: loading sales history into planning area (live cahche) take too long - up to 12-15 hours- or it ends up in short dump with runtime error "MESSAGE_TYPE_X".

Apparently we have abottlneck in loading sales history into livecache. Any idea how resolve this issue?

Kind regards

Aban

[Former Member]

The reason was cube indexes and statistics (cube for sales history) was not refreshed

[Former Member]

Hi,

This error is caused when your shared pool memory overflows.

There are several approaches to resolve this problem.

1) Increase your shared pool memory, which means you need more hardware but then there is an upper limit set by SAP for a single session. So increasing it also not going to be helpful.

2) Break your selects into smaller selects so that the memory overflow doesnt occur.

Talk to your Basis team as they will be able to consider the various options of upsizing the system.

Hope this helps.

Thanks

Mani Suresh

[Former Member]

Hi,

There could be many reasons for this.

Can you please have a quick look in the log area of LC ? It shouldn't be near 100%, in case it is so then you can take a log backup of LC.

Additionally as somebody said you can run a consistency check also. For analyzing real issues at LC DB, check the Database Analyzer log by going to Transaction DB50 -> Problem Analysis -> Performance -> Database Analyzer. You can also refer Note 819641 - FAQ: SAP MaxDB Performance

[Former Member]

Other than LC, please also check the extended memory under ST02 for your system.

[Former Member]

If possible please do the consistency check for LC. It should not take somuch time for loading Sales history.