Oracle Advanced Compression

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.

5 | P a g e – A d v a n c e d C o m p r e s s i o n compressed rows would fit into a block. With this enhancement, tables with Advanced Row Compression not only enable much faster scans, but also faster inserts than uncompressed tables, because of reduced logical and physical block gets. Migration and Best Practices

Loading..

Tags:

  Oracle, Advanced, Compression, Oracle advanced compression, A d v a n c e d c o m p r e s s i o n

Information

Related search queries