Symptom
Total allocated memory= 238.48gb (256067989504b)
Total used memory = 189.83gb (203835447231b)
Sum AB = 236636102656
Sum Used = 184403560383
Heap memory fragmentation: 20% (this value may be high if defragmentation does not help solving the current memory request)
Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
1: Column Store Tables: Pool/ColumnStore/Main/Dictionary/RoDict 28.23gb (30312706167b)
2: System: Pool/PersistenceManager/PersistentSpace/DefaultLPA/DataPage 9.36gb (10051284992b) (64mb (67108864b) precharged, 256kb (262144b) in preparation)
3: Row Store Tables: Pool/RowStoreTables/CpbTree 6.05gb (6502303968b)
4: Column Store Tables: Pool/PersistenceManager/UnifiedTableContainer 3.88gb (4167581784b)
5: System: Pool/PersistenceManager/PersistentSpace/DefaultLPA/ShadowPage 3.82gb (4110417920b) (64mb (67108864b) precharged, 16mb (16777216b) in preparation)
6: System: Pool/ColumnStore/System 2.01gb (2168289968b)
7: Caches: Pool/RowEngine/SQLPlan 1.82gb (1965004880b)
8: Monitoring & Statistical Data: Pool/Statistics 1.71gb (1841145920b)
9: System: AllocateOnlyAllocator-unlimited/FLA-UL<24592,1>/MemoryMapLevel3Nodes 1.52gb (1632687472b)
10: Column Store Tables: Pool/ColumnStore/Delta 1.25gb (1346378544b)
11: Statement Execution & Intermediate Results: Pool/malloc/libhdbcsapi.so 1.14gb (1228637093b)
12: System: Pool/malloc/libhdbcsmd.so 1.09gb (1176763136b)
13: System: Pool/RowEngine/QueryExecution/SearchAlloc 1.04gb (1125519640b)
14: Column Store Tables: Pool/ColumnStore/Main/Uncompressed 989.98mb (1038076336b)
Read more...
Environment
HANA 2.0
HANA 1.0
Keywords
KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.