Solution : https://service.sap.com/sap/support/notes/1436352 (SAP Service marketplace login required)
Summary :
SAP Note highlights the importance of database compression techniques in managing the growing demands of enterprise IT infra/power/light weight. It specifically addresses the application of Oracle's Advanced Compression Option (ACO) and standard compression features, like Index and IOT compression, which don't require ACO licensing. Prerequisites include Oracle Database release 11.2.0.2 or higher, support from SAP Kernel 6.40 onwards, and purchasing of ACO for those with direct Oracle licensing. The document also describes configurations for OLTP table compression, SecureFile compression for LOBs, RMAN Compression, and Data Guard Network Compression, detailing the advantageous reductions in storage requirements these technologies offer. Implementation advice and SQL commands for checking compression status are provided, ensuring compliance with SAP systems configurations. No sensitive security information is disclosed, focusing solely on the technical and procedural elements.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category installation information validity, oltp table compression securefile compression rman compression data guard network compression oltp table compression oltp table compression compresses data, data guard network compression dg network compression introduces, table_name compress compress_for----------- ----------- -------------coep enabled oltp securefile compression securefiles compression, long data restriction 1583303 deferred segment creation 1431800 oracle 11, advanced compression database sizethe total database size, __%pdfstyle%__ / } symptom data compression, table_name column_name sec compre ------------- --------------- ----- --------dynpsource fieldinfo, oracle compression 974876 oracle transparent data encryption, oracle databases 974876 oracle transparent data encryption
Related Notes :
| 1970224 | |
| 1922200 | TUNING INSERT PERFORMANCE ON TABLE TST03 |
| 1856270 | Performance improvements for tables with single unique index |
| 1847870 | Oracle 11g: Advanced Compression - Known issues and solution |
| 1818320 | Oracle 11g Advanced Compression for LONG data restriction |
| 1583303 | Deferred Segment Creation |
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 1431296 | LOB conversion and table compression with BRSPACE 7.20 |
| 1426979 | Oracle 11g: SecureFiles - The new way to store LOB data |
| 1289494 | FAQ: Oracle compression |
| 1109743 | Use of Index Key Compression for Oracle Databases |
| 974876 | Oracle Transparent Data Encryption (TDE) |
| 742243 | General table partitioning as of SAP_BASIS 46C |
| 712624 | High CPU consumption by Oracle |
| 500340 | FAQ: LOBS |
| 105047 | Support for Oracle functions in the SAP environment |
| 1892354 | Declustering and Depooling for Suite Optimizations |
| 1979898 |