DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Anyone User Oracle Table Compression?

  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Anyone User Oracle Table Compression?

    I just read an article on Oracle's table compression feature. This feature stores table data in a compressed format. It would be useful in our environment. I am curious if anyone has any experience with this feature? Is it ready for prime time?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Sure, for data warehouse fact tables it's very effective. For OLTP tables it's less so, partly because you need to use direct path insert to achieve compression, and partly because OLTP systems generally query individual rows.

    There's a few "gotcha's" -- can't add or drop columns from them, for one thing.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Compression doesn't do lob's of any flavor.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    The compression is done on block level and it's not the same type of compression algorithm as the one used by 'zip' or 'gzip' but a simple symbol table lookup.

    So I dont see how a lob could be compressed using this kind of compression methode.
    Last edited by mike9; 03-24-2004 at 11:01 AM.

  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yup, that's right.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width