Data_Cache is 99.97% full and CACHE_SIZE is 1362000

[Former Member]

Hi,

In our Pre - Production system (Critical for project) Data_Cache is 99.97% full. Please advise how to free up some space and best ways to maintain this in future in all systems.

Thanks,

Santos

[former_member229109]

Hello Santos,

1.

See the documents in SAP MaxDB Library

http://maxdb.sap.com/doc/7_6/default.htm -> Glossary -> Data Cache

< Then read document at Concepts of the Database System, Working Memory Areas >

2.

To get clear on the reported issue please post additional info:

Are you SAP customer?

What is the type of your database? Is it liveCache?

What is the version of your database?

How much data do you have in the database?

What is Data Cache Hit Rate?

< See the document u201CData Cache Hit Rateu201D at SAP MaxDB Library 7.6

http://maxdb.sap.com/doc/7_6/default.htm -> Tools -> Database Analyzer -> Messages >

Thank you and best regards, Natalia Khlopina