SAP Knowledge Base Article - Preview

2942253 - Large size of memory is occupied by allocators Pool/ColumnStore* or Pool/AttributeEngine-IndexVecto*

Symptom

Using script "HANA_Memory_Overview_<release>.txt" and "HANA_Memory_TopConsumers_<release>.txt" (scripts can be downloaded note 1969700) to check the memory usage status.

You notice that below allocators occupy most of total memory usage.

Pool/AttributeEngine
Pool/AttributeEngine/idattribute
Pool/AttributeEngine-IndexVector-BlockIndex
Pool/AttributeEngine-IndexVector-BTreeIndex
Pool/AttributeEngine-IndexVector-Single
Pool/AttributeEngine-IndexVector-SingleIndex
Pool/AttributeEngine-IndexVector-Sp-Cluster
Pool/AttributeEngine-IndexVector-Sp-Indirect
Pool/AttributeEngine-IndexVector-Sp-Prefix
Pool/AttributeEngine-IndexVector-Sp-Rle
Pool/AttributeEngine-IndexVector-Sp-Sparse
Pool/ColumnStore/Main/Dictionary/RoDict
Pool/ColumnStoreTables/Main/Compressed/Cluster
Pool/ColumnStoreTables/Main/Compressed/Indirect
Pool/ColumnStoreTables/Main/Compressed/Prefix
Pool/ColumnStoreTables/Main/Compressed/Rle
Pool/ColumnStoreTables/Main/Compressed/Sparse
Pool/ColumnStoreTables/Main/Dictionary/RoDict
Pool/ColumnStoreTables/Main/Dictionary/ValueDict
Pool/ColumnStoreTables/Main/Index/Block
Pool/ColumnStoreTables/Main/Index/PageableBlock
Pool/ColumnStoreTables/Main/Index/PageableSingle
Pool/ColumnStoreTables/Main/Index/Single
Pool/ColumnStoreTables/Main/PagedUncompressed
Pool/ColumnStoreTables/Main/Rowid
Pool/ColumnStoreTables/Main/Text/DocObjects
Pool/ColumnStoreTables/Main/Uncompressed
Pool/NameIdMapping/RoDict


Read more...

Environment

  • HANA database platform 1.0
  • HANA database platform 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

OOM, high memory, dump, column store, heap memory, Pool/ColumnStore/Main/Dictionary/RoDict , KBA , HAN-DB-MON , SAP HANA Monitoring , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.