3248798 - What can I do if a certain heap allocator is unusually large?

Symptom

The root cause and solution of one or more of the listed heap memory allocators on a HANA database needs to be determined :

- AllocateOnlyAllocator-limited/FLA-Li<40,64>/MinReadTSEntry
- AllocateOnlyAllocator-unlimited/FLA-UL<3145728,1>/MemoryMapLevel2Blocks (SAP HANA 1.0)
- AllocateOnlyAllocator-unlimited/FLA-UL<24592,1>/MemoryMapLevel3Nodes (SAP HANA >= 2.0)
- Pool/AdapterOperationCache
- Pool/ASTRuleEngine
- Pool/ASTRuleEngine/ASTRuleEngine ExternalApi
- Pool/Auditing
- Pool/BackupCopier/SynchronousPoolCopyHandler
- Pool/BWFlattenScenario
- Pool/BackupRecoveryAllocator
- Pool/BitVector
- Pool/BWFlattenScenario
- Pool/CacheMgr/CS_StatisticsCache
- Pool/CacheMgr/DataStatisticsAdviserCache
- Pool/CacheTransContainer
- Pool/CalculationEngine
- Pool/CalculationEngine/ceQOExecutor
- Pool/CalculationEngine/query/pops
- Pool/ChannelUtils/SynchronousPoolCopyHandler
- Pool/ColumnStore/Delta
- Pool/ColumnStoreTables/Delta
- Pool/ColumnStore/Delta/BtreeDictionary
- Pool/ColumnStore/Delta/Btreeindex
- Pool/ColumnStore/Delta/Cache
- Pool/ColumnStore/Delta/InternalNodes
- Pool/ColumnStore/Delta/LeafNodes
- Pool/ColumnStoreTables/Delta/BtreeDictionary
- Pool/ColumnStoreTables/Delta/Btreeindex
- Pool/ColumnStoreTables/Delta/Cache
- Pool/ColumnStoreTables/Delta/InternalNodes
- Pool/ColumnStoreTables/Delta/LeafNodes
- Pool/ColumnStore/Main/Compressed/Cluster
- Pool/ColumnStore/Main/Compressed/Indirect
- Pool/ColumnStore/Main/Compressed/Prefix
- Pool/ColumnStore/Main/Compressed/Rle
- Pool/ColumnStore/Main/Compressed/Sparse
- Pool/ColumnStore/Main/Dictionary/RoDict
- Pool/ColumnStore/Main/Dictionary/ValueDict
- Pool/ColumnStore/Main/Index/Block
- Pool/ColumnStore/Main/Index/PageableSingle
- Pool/ColumnStore/Main/Index/Single
- Pool/ColumnStore/Main/PagedUncompressed
- Pool/ColumnStore/Main/Rowid
- Pool/ColumnStore/Main/Text/DocObjects
- Pool/ColumnStore/Main/Uncompressed
- 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/Single
- Pool/ColumnStoreTables/Main/PagedUncompressed
- Pool/ColumnStoreTables/Main/Rowid
- Pool/ColumnStoreTables/Main/Text/DocObjects
- Pool/ColumnStoreTables/Main/Uncompressed
- Pool/ColumnStore/Main/Rowid/build-reverse-index
- Pool/ColumnStoreTables/Main/Rowid/build-reverse-index
- Pool/ColumnStore/System
- Pool/ColumnStore/Transient
- Pool/ColumnStore/Transient/updateContainerConcat
- Pool/commlibDefAllocator
- Pool/ncCommLibDefAllocator
- Pool/Contexts
- Pool/Crypto
- Pool/CS/BufferPage
- Pool/CSPlanExecutor/PlanExecution
- Pool/CSRowLocking
- Pool/CS_TableSearch
- Pool/Currency/Unit Conversion/conversion/currency
- Pool/DeletedPageList
- Pool/DocidValueArray
- Pool/DPServerFramework
- Pool/DPServerStatsRequestIfacerAllocator
- Pool/DSO/DSORead
- Pool/DSO/DSOUpdate
- Pool/DynamicCachedView
- Pool/DynamicCachedView/ViewMatching
- Pool/entityCache
- Pool/ESX
- Pool/Exception
- Pool/ExecutorPlanExecution
- Pool/ExpressionGlobal/Expression
- Pool/Federation/FederationAdapter
- Pool/FemsCompression/CompositeFemsCompression
- Pool/Filter
- Pool/FRSWLockAllocator
- Pool/FuzzySearch
- Pool/hierarchyBlob
- Pool/hierarchiesItab
- Pool/HierarchyFunctionsGeneralExec
- Pool/HierarchyFunctionsIncrementalLoad
- Pool/HierarchyFunctionsRecursiveExec
- Pool/HierarchyFunctionsSingleton
- Pool/ICT
- Pool/ImportExport
- Pool/IndexRebuildAllocator
- Pool/IndexManager
- Pool/IndexVector
- Pool/IndexVectorAligned
- Pool/itab
- Pool/itab/expr
- Pool/itab/FindBlocks2
- Pool/itab/VectorColumn
- Pool/JERequestHandler
- Pool/JoinEvaluator
- Pool/JoinEvaluator/DictsAndDocs
- Pool/JoinEvaluator/IndexInfo
- Pool/JoinEvaluator/JECalculate
- Pool/JoinEvaluator/JECalculate/TmpResults
- Pool/JoinEvaluator/JECreateNTuple
- Pool/JoinEvaluator/JEPreAggregate
- Pool/JoinEvaluator/JEStep1
- Pool/JoinEvaluator/JEStep2
- Pool/JoinEvaluator/NTuple
- Pool/JoinEvaluator/JEEvalPrecond
- Pool/JoinEvaluator/JEPlanData/deserialized
- Pool/JoinEvaluator/JEAggregate
- Pool/JoinEvaluator/JEAggregate/Results
- Pool/JoinEvaluator/JEAssembleResults
- Pool/JoinEvaluator/JEAssembleResults/Results
- Pool/JoinEvaluator/JECalculate/Results
- Pool/JoinEvaluator/JERequestedAttributes/Results
- Pool/JoinEvaluator/PlanCache
- Pool/JoinEvaluator/PlanDataAttrVals/Deserialized
- Pool/JoinEvaluator/TranslationTable
- Pool/JoinEvaluator/ValueList
- Pool/KernelSentinel
- Pool/L/jit/CodeCache
- Pool/L/jit/MetaData
- Pool/L/llang/Code
- Pool/L/llang/CodeCache
- Pool/L/llang/Interfaces
- Pool/L/llang/Debuggee
- Pool/L/llang/Runtime/Global
- Pool/L/llang/Runtime/Local
- Pool/LVCAllocator/LVCContainerDir
- Pool/LVCAllocator/LVCContainerDir/LVCContainer_<id>
- Pool/LVCAllocator/LVCObjectPageDir
- Pool/LVCAllocator/LVC_ObjectPageDir
- Pool/LVCAllocator/OMSAllocator/Session_<conn_id>/OMSSession/OMSDefaultContext
- Pool/LVCAllocator/OMSAllocator/Session_<conn_id>/USERSession/OMS User COMRoutine
- Pool/LOBStorage
- Pool/malloc/hdbindexserver
- Pool/malloc/hdbnameserver
- Pool/malloc/libafludfcore.so
- Pool/malloc/libc.so.6
- Pool/malloc/libdbrsa16_r.so
- Pool/malloc/libdbrsa17_r.so
- Pool/malloc/libdqmatchtransformu.so
- Pool/malloc/libhdbbasement.so
- Pool/malloc/libhdbcalcengine.so
- Pool/malloc/libhdbcalcengineapi.so
- Pool/malloc/libhdbcalcenginepops.so
- Pool/malloc/libhdbcs.so
- Pool/malloc/libhdbcsaccessstatisticscache.so
- Pool/malloc/libhdbcsapi.so
- Pool/malloc/libhdbcsmd.so
- Pool/malloc/libhdbcsstore.so
- Pool/malloc/libhdbcstypes.so
- Pool/malloc/libhdbcswrapper.so
- Pool/malloc/libhdbdistmetadata.so
- Pool/malloc/libhdbevaluator.so
- Pool/malloc/libhdbhierarchies_functions.so
- Pool/malloc/libhdbitab.so
- Pool/malloc/libhdbmdsmemorypersistent.so
- Pool/malloc/libhdbmetadataobject.so
- Pool/malloc/libhdbolap.so
- Pool/malloc/libhdbpartitioning.so
- Pool/malloc/libhdbpythonbase.so
- Pool/malloc/libhdbrskernel.so
- Pool/malloc/libhdbsqlparser.so
- Pool/malloc/libhdbtableconsistencycheck.so
- Pool/malloc/libodbcHDB.so
- Pool/malloc/libsapcrypto.so
- Pool/malloc/libstdc++.so.6
- Pool/M_CONSISTENT_VIEW_STATISTICS
- Pool/M_DELTA_MERGE_STATISTICS
- Pool/M_DEV_REP_DMLLOGREPLAYER
- Pool/M_DEV_REP_LOGDISPATCHER
- Pool/M_DEV_RS_INDEX_DEPENDENCY_COUNTER
- Pool/M_DEV_RS_INDEX_DEPENDENCY_COUNTER_HOLDER
- Pool/M_EXECUTED_STATEMENTS
- Pool/M_EXPENSIVE_STATEMENTS
- Pool/M_LAZY_TIMESTAMP_DISTRIBUTION_MANAGER
- Pool/M_SERVICE_THREAD_SAMPLES
- Pool/M_TRANSACTION_MANAGER
- Pool/M_TRANSACTION_REQUESTS
- Pool/M_TRANSTOKEN_CONTAINERS
- Pool/M_TRANS_TOKENS
- Pool/mds
- Pool/mds/CubeAxis
- Pool/mdx
- Pool/Metadata
- Pool/Metadata/MetadataCache/MetadataGlobalCacheSlot
- Pool/Metadata/SessionLocalItabContainer
- Pool/Metadata/TransientMetadata
- Pool/NetworkChannelCompletionHandler
- Pool/NonExecutorActivitiesRoot/NonExecutorActivities2
- Pool/OptimizeCompression/<schema>:<table>
- Pool/OptimizeCompression/<schema>:_SYS_SPLIT_<table>~<partition>
- Pool/parallel
- Pool/parallel/aggregates
- Pool/parallel/align
- Pool/parallel/compactcol
- Pool/parallel/ihm
- Pool/parallel/pop
- Pool/parallel/temp_aggregates
- Pool/parallel/temp_dimensions
- Pool/parallel/temp_other
- Pool/PerformanceAnalyzer
- Pool/PersistenceLayer
- Pool/PersistenceManager
- Pool/PersistenceManager/Backup
- Pool/PersistenceManager/Backup/Superblock
- Pool/PersistenceManager/ContainerFileIDMapping
- Pool/PersistenceManager/DisasterRecoveryPrimary
- Pool/PersistenceManager/DisasterRecoverySecondary
- Pool/PersistenceManager/DisasterRecoverySecondary/ReplayLogCache
- Pool/PersistenceManager/LOBContainerDirectory
- Pool/PersistenceManager/LogRecovery
- Pool/PersistenceManager/MidSizeLOBContainerFileIDMapping
- Pool/PersistenceManager/MidSizeLOBContainerFileIDMapping/BackMap
- Pool/PersistenceManager/MidSizeLOBContainerFileIDMapping/EidMap
- Pool/PersistenceManager/MidSizeLOBContainerFileIDMapping/OwnerBackMap
- Pool/PersistenceManager/PersistentSpace/DefaultConverter/ConvPage
- Pool/PersistenceManager/PersistentSpace/DefaultLPA
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/LOBControlblock
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/LOBPage
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/LOBPageControlblock
- Pool/PersistenceManager/PersistentSpace/LOBPageProvider:Controlblock
- Pool/PersistenceManager/PersistentSpace/LOBPageProvider:DataPage
- Pool/PersistenceManager/PersistentSpace(0)/DefaultLPA/Page
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/Page
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/DataPage
- Pool/PersistenceManager/PersistentSpace/DefaultPageProvider:DataPage
- Pool/PersistenceManager/PersistentSpace(0)/DefaultLPA/ShadowPage
- Pool/PersistenceManager/PersistentSpace/DefaultLPA/ShadowPage
- Pool/PersistenceManager/PersistentSpace(0)/PageChunk
- Pool/PersistenceManager/PersistentSpace/PageChunk
- Pool/PersistenceManager/PersistentSpace(0)/RowStoreLPA
- Pool/PersistenceManager/PersistentSpace/RowStoreLPA
- Pool/PersistenceManager/PersistentSpace(0)/RowStoreLPA/RowStoreSegment
- Pool/PersistenceManager/PersistentSpace/RowStoreLPA/RowStoreSegment
- Pool/PersistenceManager/PersistentSpace(0)/RowStoreLPA/Superblock
- Pool/PersistenceManager/PersistentSpace/RowStoreLPA/Superblock
- Pool/PersistenceManager/PersistentSpace/StaticLPA/DataPage
- Pool/PersistenceManager/PersistentSpace(0)/StaticLPA/Page
- Pool/PersistenceManager/PersistentSpace/StaticLPA/Page
- Pool/PersistenceManager/PersistentSpace/TempLPA/DataPage
- Pool/PersistenceManager/PersistentSpace/TempLPA/Page
- Pool/PersistenceManager/TemporaryUnifiedTableContainer
- Pool/PersistenceManager/UndoDirectory
- Pool/PersistenceManager/UnifiedTable container
- Pool/PersistenceManager/UnifiedTableContainer
- Pool/PersistenceManager/UnifiedTableContainer/MVCC
- Pool/PersistenceManager/VarSizeEntryFreeSpaceInformation
- Pool/PersistenceManager/VirtualFile entry TID map
- Pool/PlanningEngine/Buffer
- Pool/PlanningEngine/Compile
- Pool/PlanningEngine/Fox
- Pool/PlanningEngine/LookupDict
- Pool/planviz/column store/plans
- Pool/planviz/column store/plans/ParentCycleDetector
- Pool/planviz/column store/PlanVizContext
- Pool/planviz/column store/PlanVizContext/JsonAllocator
- Pool/planviz/common/final results
- Pool/planviz/common/strings
- Pool/planviz/sql layer/PlanVizContext
- Pool/planviz/sql layer/PlanVizContext/PlanVizParams
- Pool/QueryLanguage
- Pool/QueryMediator
- Pool/ReplicationLogReceiverAllocator
- Pool/ResourceContainer
- Pool/ResourceContainer/ResourceHeader
- Pool/ResultCache(for cached view)
- Pool/RowEngine/ColumnEngineWrapper
- Pool/RowEngine/Communication
- Pool/RowEngine/CpbTree
- Pool/RowStoreTables/CpbTree
- Pool/RowEngine/GlobalHeap
- Pool/RowEngine/IndexRebuild
- Pool/RowEngine/LOB
- Pool/RowEngine/LockTable
- Pool/RowStoreTables/LockTable
- Pool/RowEngine/LoggingContext
- Pool/RowEngine/MonitorView
- Pool/RowEngine/MonitorView/<monitor_view_name>
- Pool/RowEngine/MonitorView/M_MERGED_TRACES
- Pool/RowEngine/MonitorView/StatisticsMonitors/<monitor_view_name>
- Pool/RowEngine/MonitorView/StatisticsMonitors/M_CONTEXT_MEMORY
- Pool/RowEngine/MonitorView/StatisticsMonitors/M_DEV_BACKUP_CATALOG_LOG
- Pool/RowEngine/MonitorView/StatisticsMonitors/M_DEV_BACKUP_CATALOG_LOG_FILES
- Pool/RowEngine/MonitorView/StatisticsMonitors/M_DEV_INDEX_COLUMNS
- Pool/RowEngine/MonitorView/StatisticsMonitors/M_UNDO_CLEANUP_FILES
- Pool/RowEngine/QueryCompilation
- Pool/RowEngine/QueryCompilation/SqlOptAlloc/qoContextAlloc
- Pool/RowEngine/QueryCompilation/SqlOptAlloc/QoHex
- Pool/RowEngine/QueryExecution
- Pool/RowEngine/QueryExecution/SearchAlloc
- Pool/RowEngine/RowTableManager/MVCCManager/MVCCAllocator
- Pool/RowEngine/RSTempPage
- Pool/RowEngine/Session
- Pool/RowEngine/SQLPlan
- Pool/RowEngine/SQLPlanInfos
- Pool/RowEngine/SQLPlanStatistics
- Pool/RowEngine/TableDMLRuntimeData
- Pool/RowEngine/TableRuntimeData
- Pool/RowEngine/Version
- Pool/RowStoreTables/Version
- Pool/RowEngine/ViewCache
- Pool/RowTableUpdateAllocator
- Pool/SearchAPI
- Pool/SearchAPI/Itab Search
- Pool/Search/PreparedQuery
- Pool/SerializedObject
- Pool/SharedFederation/Odm
- Pool/SingleValueCacheBuilder
- Pool/spatialcs
- Pool/SQLChecker
- Pool/SQLParserGlobal/SQLParserParse
- Pool/SQLPreprocessor
- Pool/SQLScript/Compile
- Pool/SQLScript/Execution
- Pool/SQLScript/Execution/Code
- Pool/SQLScript/Execution/ManagedInvoke
- Pool/SQLScript/Supportability
- Pool/SQLTraceContext
- Pool/Statistics
- Pool/Statistics/Allocators/CoreStripedSubStats
- Pool/Statistics/Allocators/Limits/CoreStripedLimits
- Pool/Statistics/ReadWriteLocks
- Pool/Statistics/Semaphores/CondVars
- Pool/StatisticsServer/ThreadManager/Stats::Thread_<num>
- Pool/StatisticsServer/JobManager/Stats::Thread_<num>
- Pool/StatisticsServer/JobManager/WriteLastValuesJob
- Pool/StatisticsServer/LastValuesHolder
- Pool/StringContainer
- Pool/TableConsistencyCheck
- Pool/TableUpdate
- Pool/TableUpdate/PreparedInfo
- Pool/Text/AEText
- Pool/Text/AEText/phrase_index
- Pool/Text/AEText/split_document_index
- Pool/Text/AEText/split_positional_index
- Pool/Text/AEText/termset_container
- Pool/Text/AEText/text_property_index
- Pool/Text/TextAttribute
- Pool/TransactionManager
- Pool/TransMgr
- Pool/TransientMetadataAlloc
- Pool/CacheFramwork/CacheMgr/CalcEngineNodeCache
- Pool/TREXCache/CacheMgr/CalcEngineNodeCache
- Pool/CacheFramework/CacheMgr/CE_ScenarioModelCache
- Pool/TREXCache/CacheMgr/CE_ScenarioModelCache
- Pool/CacheMgr/CE_ScenarioModelCache
- Pool/CacheFramework/CacheMgr/cs_access_statistics
- Pool/TREXCache/CacheMgr/cs_access_statistics
- Pool/CacheFramework/CacheMgr/CS_QueryResultCache[Realtime]
- Pool/CacheFramework/CacheMgr/CS_QueryResultCache[TimeControlled]
- Pool/TREXCache/CacheMgr/CS_QueryResultCache[Realtime]
- Pool/TREXCache/CacheMgr/CS_QueryResultCache[TimeControlled]
- Pool/CacheMgr/CS_QueryResultCache[Realtime]
- Pool/CacheMgr/CS_QueryResultCache[TimeControlled]
- Pool/CacheFramework/CacheMgr/CS_StatisticsCache
- Pool/TREXCache/CacheMgr/CS_StatisticsCache
- Pool/CacheMgr/CS_StatisticsCache
- Pool/CacheFramework/CacheMgr/Currency/UnitConversion_RateQueriesResultCache
- Pool/TREXCache/CacheMgr/Currency/UnitConversion_RateQueriesResultCache
- Pool/CacheMgr/Currency/UnitConversion_RateQueriesResultCache
- Pool/CacheFramework/CacheMgr/DataStatisticsAdviserCache
- Pool/TREXCache/CacheMgr/DataStatisticsAdviserCache
- Pool/CacheMgr/DataStatisticsAdviserCache
- Pool/trex_wrapper_body
- Pool/AFL_UDF_CORE
- Pool/AFL_XRP
- Pool/OSA/AnalyticalToolOSA
- Pool/OSA/CreateIntraWeekPattern
- Pool/OSA/EstimateModel
- Pool/OSA/MonitorOSA
- Pool/OSA/Singleton
- Pool/UdivListMgr/UdivListContainer
- Pool/ValueArray
- Pool/ValueArrayColumnDeserialize
- Pool/XDictData
- Pool/XSEngine/AppRegistry
- Pool/XSEngine/XSJobScheduler/_<application>
- Pool/XSEngine/XSJobScheduler/_<application>/_<job_name>
- StackAllocator
- VirtualAlloc

Memory may be exhausted or shrinking on the HANA database also :

GLOBAL_ALLOCATION_LIMIT (GAL) = 292.84gb (314438582272b), SHARED_MEMORY = 9.68gb (10398846976b), CODE_SIZE = 1.96gb (2109448192b), OOM_RESERVATION_ALLOCATOR_SIZE = 96.14mb (100810752b)
PID=29120 (hdbindexserver), PAL=358.06gb (384468295680b), AB=259.66gb (278811996160b), UA=0, U=218.39gb (234498140121b), FSL=0b, FMC=0b
[Some processes may have been skipped]
Total allocated memory= 290.08gb (311478321152b)
Total used memory     = 245.53gb (263640951799b)
Sum AB                = 298970025984
Sum Used              = 251132656631
Heap memory fragmentation: 15

Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
 1: Statement Execution & Intermediate Results: Pool/JoinEvaluator/JERequestedAttributes/Results                     90.37gb (97041022320b) (512mb (536870912b) precharged, 48.90mb (51281920b) in preparation)
 2: System:                                     AllocateOnlyAllocator-unlimited/FLA-UL<24592,1>/MemoryMapLevel3Nodes 15.69gb (16853881280b)
 3: Column Store Tables:                        Pool/PersistenceManager/UnifiedTableContainer                        11.69gb (12556655804b)
 4: System:                                     Pool/RowEngine/ColumnEngineWrapper                                   9.72gb (10444201880b)

. . . .

Environment

SAP HANA, platform edition 2.0

SAP HANA, platform edition 1.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.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.