Pin area hitrate <percentage>%, <number> of <number_of> accesses failed, pin area used : <used_percentage>%
With the definition of a special attribute (CACHE) tables can be "pinned" into the data cache. The used LRU (least recently used) mechanism is influenced and the data is kept longer in the cache than usual.
The message informs about the usage of these pin areas. If it is too small not all tables with the CACHE attribute can be kept in the cache and this will lead to a bad hitrate.
In case of an extensive use of pinned tables the defined pin area might be configured too small and should be enlarged.
Relevant DB-Analyzer Files
Helpful with ...
|DBAN_CACHES.csv||Information on pinned pages, hitrates.|
|1474589 - FAQ: SAP MaxDB Object Pinning||In process. German only. Might be helpful anyway.|
Content / Helpful with ...
Internal only: No recorded expert session available. Find some information in delta powerpoints to 7.9.
|Short description of table pinning.|