Low Catalog Cache Hitrate

[Former Member]

Hi,

Currently, our APO production system has a low catalog cache hitrate of 80%. This hitrate rarely climbs up to a value greater than 85%.

Can anybody help me in identifying the factors that affect this? How can we improve this?

Below are current statistics and parameters in the system:

Cache Sizes

Size in KB Size in pages

I/O Buffer Cache 3,353,808 419,226

Data Cache 3,351,552 418,944

Converter 1,952 244

Other 304 38

Catalog Cache 35,328 4,416

Sequence Cache 8 1

Cache Accesses

Accesses Successful Unsuccessful Hit Rate

Entire Data Cache 210,815,372 210,739,279 76,093 99.96%

History/Undo 20,076,913 20,076,913 0 100.00%

OMS Data 158,934,232 158,861,439 72,793 99.95%

SQL Data 31,804,227 31,800,927 3,300 99.99%

Catalog Cache 20,212,459 16,282,442 3,928,363 80.56%

Sequence Cache 0 0 0 100.00%

Data Cache Usage

Usage in KB Usage in Pages Occup.

Entire Data Cache 1,386,752 173,344 41.38%

SQL Data 30,432 3,804 0.91%

OMS Data 722,328 90,291 21.55%

History/Undo 633,816 79,227 18.91%

Cache-Specific Parameter Settings

CACHE_SIZE = 419226

CAT_CACHE_SUPPLY = 4416

Let me know what your comments and suggestions.

Thanks in advance.

Best regards,

Kris Caldoza

[somnath_manna · Accepted solution]

Hi Kris,

I doubt if anyone in this Forum can answer this.

suggest you put in a thread in the forum MaxDB / liveCache

Regards,

Somnath

[Former Member · Accepted solution]

Thanks Somnath...