Wednesday, July 2, 2014

Why you should use oracle advanced compression


  • Explosion in Data Volumes
  • As data volume expands performance often declines
  • Disk costs money
  • Transparent to applications, SQL, and PL/SQL
  • Use spare CPU cycles to decrease the bytes written and read
  • Transparent to applications, SQL, and PL/SQL
  • May improve performance by requiring the transfer of  fewer bytes from disk through the network, into the CPU,  to be stored in the buffer cache
  • Increase the amount of data stored on existing disk
  • Compression is performed at the block level
  • Data Guard Network Compression
  • Data Pump Compression
  • Fast RMAN Compression
  • OLTP Table Compression

References
  • http://www.morganslibrary.com/pres/ougf_advcomp_2009.pdf

No comments:

Post a Comment