Advertisement

Compression

  • David Fitzjarrell
  • Mary Mikell Spence
Chapter

Abstract

Oracle Release 11.2 offers Advanced Compression, a way to reduce the overall size of your data by compressing commonly occurring values and strings with tokens, mnemonics that can represent much larger strings and values. Two types of compression are offered on systems not using Exadata-type storage: Basic and OLTP. Basic compression is available without the Advanced Compression licensing. A third compression option, Hybrid Columnar Compression (HCC), is available on Exadata systems and non-Exadata systems using Exadata-type storage. This is offered in two basic levels: QUERY and ARCHIVE.

Keywords

Compression Ratio Elapse Time Data Block Data Dictionary Compression Level 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© David Fitzjarrell 2013

Authors and Affiliations

  • David Fitzjarrell
    • 1
  • Mary Mikell Spence
    • 1
  1. 1.ColoradoUS

Personalised recommendations