Advanced Compression in Oracle Database 11g

Introducing Advanced Compression

• Advanced compression in Oracle Database 11g
  • Structured data compression
  • Unstructured data compression
  • Compression for backup data
  • Network transport compression
• Reduces resource requirements and costs
  • Storage System
  • Network Bandwidth
  • Memory Usage

OLTP Table CompressionNew in Oracle Database 11g

• Table compression for conventional DML Operations
  • INSERT, UPDATE, DELETE
• New algorithm significantly reduces write overhead
  • Batched compression ensures no impact for most OLTP transactions
• Faster reads
  • Fewer I/Os and enhanced memory efficiency

Unstructured Data Compression Oracle SecureFiles

• New feature in Oracle Database 11g
• Secure, high performance, storage optimized solution
• Documents, spreadsheets, images, multimedia, etc.
• SecureFile Compression
  • Automatically determines if SecureFile data is compressible
  • 2 to 4x compression for typical files
  • Industry standard compression algorithms
  • Multiple compression levels optimize performance and space

Network Compression Oracle Data Guard Redo Transport Services

• Fast re-sync of standby database after network outages
• Lower bandwidth networks (<100Mbps)
  • 15-35% less time required to transmit 1 GB of data
  • Bandwidth consumption reduced up to 35%
• High bandwidth networks (>100 Mbps)
  • Compression will not reduce transmission time
  • But will reduce bandwidth consumption up to 35%

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Oracle Advanced Compression:Throw Away Half of Your Disks and Run Your Database Faster
2. 11g compression 新特性(1)
3. How to Make Use of Oracle's Data Compression with Materialized Views.
4. A Complete Understanding of RMAN Compression
5. Oracle Database 11g: Change Management Overview eStudy
6. Oracle Database 11g: New Features Overview eStudy Student Guide
7. Oracle 11g Competing Against IBM DB2 9.5 for Linux,Unix and Windows
8. Oracle Database 11g: Program Development Student Guide
9. Oracle Database 11g: Server Manageability Student Guide
10. Oracle Database 11g: High Availability Student Guide