3 Replies Latest reply: Aug 21, 2012 2:47 PM by Uwehesse-Oracle RSS

    Exadata: Compression

    921749
      Hi,

      I have a couple of questions on Compression on Exadata.

      1. Is there a query/way to estimate the amount of compression that can be done?
      2. How would we be able to define which compression is best done ?

      Thanks,
        • 1. Re: Exadata: Compression
          kuljeet singh -
          1. Is there a query/way to estimate the amount of compression that can be done?
          yes by Compression Advisor.

          Exadata Hybrid Columnar Compression Advisor [ID 1269846.1]
          • 2. Re: Exadata: Compression
            Dave M.-Oracle
            The My Oracle Support Community which covers all support related questions about EXADATA is available under: https://communities.oracle.com/portal/server.pt/community/exadata_general/360

            Have you ever visited the Community to exchange, learn, share and get answers to your support related questions?

            Additional details about the availability of the Compression Advisor are available on the My Oracle Support Community for Exadata
            https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=415389&aggregatorResults=T415389T413441T412868T412171T392700T388082T386686T390659T370132T394094&sourceCommunityId=360&sourcePortletId=268&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https%3A%2F%2Fcommunities.oracle.com%2Fportal%2Fserver.pt%3Fopen%3Dspace%26name%3DCommunityPage%26id%3D47%26psname%3DOpener%26psid%3D46%26cached%3Dtrue%26in_hi_userid%3D173523%26control%3DSetCommunity%26PageID%3D0%26CommunityID%3D360%26&Portlet=All%20Community%20Discussions&PrevPage=Communities-CommunityHome

            If you have not used the My Oracle Support Communities before, please watch this brief (2 minute) video to help you quickly understand the benefits available to you.
            http://bcove.me/rvjqwdn5

            At your service,

            Dave M.
            • 3. Re: Exadata: Compression
              Uwehesse-Oracle
              Incidentally I have covered your two questions with blog posts:

              1) http://uhesse.com/2011/09/12/dbms_compression-example/
              2) http://uhesse.com/2011/01/21/exadata-part-iii-compression/

              Kind regards
              Uwe Hesse

              "Don't believe it, test it!"
              http://uhesse.com