This discussion is archived
3 Replies Latest reply: Aug 21, 2012 12:47 PM by UweHesse RSS

Exadata: Compression

921749 Newbie
Currently Being Moderated
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
    KuljeetPalSingh Guru
    Currently Being Moderated
    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. Journeyer
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points