Solution : https://service.sap.com/sap/support/notes/1426979 (SAP Service marketplace login required)
Summary :
This SAP Note outlines the features of Oracle 11g's SECUREFILES, a new method for storing LOB (Large Object) data, including BLOBs and CLOBs. It introduces an advancement over the previous method, BasicFiles, offering enhanced performance, especially for LOB sizes over 8KB, due to optimized algorithms that reduce CPU utilization. SECUREFILES also supports advanced features like compression with varying levels, encryption through Transparent Data Encryption (TDE), and advanced logging options. Additionally, it integrates with several Oracle Database capabilities including transactions, partitioning, and Automatic Storage Management (ASM). For SAP systems, usage conditions and prerequisites like appropriate setting of the 'db_securefile' initialization parameter and patch applications are detailed to ensure compatibility and system stability.
Key words :
terms oracle securefiles lob blob clob 11g assm solution oracle 11g introduces, oracle rac securefiles provide higher scalalibity, lob columns oracle 11g introduced, convert existing long data directly, oracle database guarantees transactional consistency, database supports automatic key management, 20 br tools support online migration, examples basicfile lobcreate table basicfil, compression degree = highcreate table secufil, oracle 11g feature
Related Notes :
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 1431296 | LOB conversion and table compression with BRSPACE 7.20 |
| 1386733 | Empty menu options |
| 949737 | Generating screen & CUA loads in own LUW |