Forum Stats

  • 3,851,383 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

Table compresion in 11gR2 exadata

800104
800104 Member Posts: 86
edited Apr 20, 2011 1:58AM in Advanced Compression
I have a exadata machine with 11gR2--11.2.0.1 database..

My tables are of huge size above 150 GB..

Suppose I have a table of 200Gb..

Can somebody propose me compression method that is best suitable...I dont want to use hybrid columnar compression..

Answers

  • Surachart Opun
    Surachart Opun Member Posts: 1,662
    user12549504 wrote:
    I have a exadata machine with 11gR2--11.2.0.1 database..

    My tables are of huge size above 150 GB..

    Suppose I have a table of 200Gb..

    Can somebody propose me compression method that is best suitable...I dont want to use hybrid columnar compression..
    check http://uhesse.wordpress.com/2011/01/21/exadata-part-iii-compression/

    On, 11g, if not use HCC

    BASIC compression for Data Warehouse
    OLTP compression for OLTP Databases

    and * COMPRESS FOR OLTP and COMPRESS BASIC are not supported for tables with more than 255 columns.
    Surachart Opun
This discussion has been closed.