Solution : https://service.sap.com/sap/support/notes/1289494 (SAP Service marketplace login required)
Summary :
This SAP Note explores the implementation and management of data compression in Oracle environments as integrated within SAP systems. It addresses types of compression applicable to both indexes and tables, suchly index, table, and Securefile compressions, but excludes backup and BI specific compressions. Notable benefits like decreased storage requirements, cost savings, and performance enhancements are highlighted. Furthermore, guidelines for activating or deactivating index and table compressions, especially in partitioned scenarios, are thoroughly discussed. Technical details concerning the permissible extent of compression in the SAP landscape and considerations for maintaining compression settings during index rebuilds or table reorganizations are also elaborated. Recommendations for handling common issues related to the operations on compressed data structures are provided to help optimize database efficiency and integrity.
Key words :
higher data density improved system performance, smaller database size lower costs, export dump files bi compression, data pump dump files, data guard network data, store oracle monitoring data, oracle buffer pool due, compression means transforming data, advanced compression option includes, sap deliver compressed tables
Related Notes :
| 1464156 | Support for index compression in BRSPACE 7.20 |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1431296 | LOB conversion and table compression with BRSPACE 7.20 |
| 1109743 | Use of Index Key Compression for Oracle Databases |
| 701235 | Usage of Oracle compression and BW |
| 105047 | Support for Oracle functions in the SAP environment |