Transcription of Oracle Advanced Compression
{{id}} {{{paragraph}}}
Oracle Advanced Compression ORAC LE WHITE P APER | FE BRU ARY 2019. Table of Contents 0. Introduction 2. Data Compression 3. Migration and Best Practices 5. Unstructured Data Compression 7. Backup Compression 8. Index Compression 10. Network Compression 10. Data Guard Redo Transport Compression 11. Information Lifecycle Management 11. Heat Map 11. Automatic Data Optimization 12. Additional Capabilities 13. Optimization for Flashback Data Archive History Tables 13. Storage Snapshot Optimization 13. Hybrid Columnar Compression Row Level Locking 14. Exadata Flash Cache Compression 14. Online Move Table/Partition/Subpartition (to a compressed format) 14. Conclusion 15. Disclaimer 15. Introduction The amount of data that enterprises are storing, and managing, is growing rapidly - various industry estimates indicate that data volume is doubling every 2-3 years. This exponential growth of data presents daunting challenges for IT. First, and foremost, are storage costs: even though the cost of storage has been declining dramatically, the enormous growth in the volume of data still makes storage one of the biggest cost elements of most IT budgets.
these requirements by locking and compressing only those rows that are uncompressed and unlocked - hence it can take place in the presence of other uncommitted transactions in the block. Background Compression Typically, Advanced Row Compression block compression is only triggered using direct load operations or by DML insert/update operations.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}