Skip to Content
0
Former Member
Mar 15, 2013 at 04:29 PM

SAP LiveCache OneDB Management

47 Views

Hi experts,

We have installed an SAP SCM 7.0 Ehp2 system with APO OneDB (MaxDB).

Physical memory of this system is about 36 Go and Data cache size is 12 Go.

We have applied all recommendations resulting from Dbanalyzer.

Furthermore, we applied OSS Note 1567117 recommendations .

Standards jobs /SAPAPO/OM_DELETE_OLD_SIMSESS & /SAPAPO/OM_REORG_DAILY are scheduled.

For now, our integrator is working to initialize this solution (Dev environement).

It seems that, after one day of working, we had to stop/start SAP in order to release Data Cache Usage (100%).

After that, it seems that Data Cache Usage grows too faster.

For now, Entire Data Cache usage : 5 152 000 KB :

  • History/Undo : 0
  • OMS Data : 0
  • SQL Data : 5 139 000

I read that normally, SQL Data is about 2 or 3 % of the total data cache size.

In CACHE_OCCUPANCY.csv file (Database Analyzer -> Expert Analysis menu in DB59), we can see SQL_Pages over than 640000 pages whereas Data Cache Size is 1 280 000 pages (SQL Data = 50% of Data Cahce Size).

Is it normal?

Can you explain how SQL Data management works?

Why this Data Cache part of memory isn’t released automatically?

Regards

Thanks