Solution : https://service.sap.com/sap/support/notes/1813245 (Connexion à SAP Service Marketplace requise)
Résumé :
This SAP Note highlights the challenge of high fragmentation in the row store memory, where the physical size greatly exceeds the actual data size, leading to inefficient space utilization. The advised solution involves row store defragmentation through reorganization strategies, offered in two modes: offline and online. Offline reorganization is preferable for maximum compaction, occurring during system restarts to ensure no transactional activities interfere. Online reorganization can be performed during runtime but may result in reduced performance and persisting fragmentation. Essential prerequisites include running on HANA Database Revision 50 or later, and ensuring catalog integrity before proceeding with the recommended reorganization strategy if conditions indicate substantial free memory space available.
Mots Clés :
components han-db-eng-bw sap hana bw engine priority recommendations / additional info category consulting validity software componentfrom rel, execute online row store reorganization commandalter system reclaim data space, solution offline row store reorganization offline row store reorganization, __%pdfstyle%__ / } symptom row store memory size, online row store reorganization acquires exclusive table lock, customer component han-db sap hana database, /sys/global/hdb/custom/config open indexserver, parameter[row_engine]page_compaction_enable = truepage_compaction_max_pages = 2097152 online row store reorganization note, online row store reorganization row store reorganization, online row store reorgainzation finishes reorganization
Notes associées :
| 1977584 | Technical Consistency Checks for SAP HANA Databases |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |
| 2066225 | SAP HANA DB: Known issues detected in SPS08 |
| 2078667 | SAP HANA: negative values returned from SYS.M_RS_MEMORY |