Home » RDBMS Server » Server Administration » compress tables (11.2.0.4)
compress tables [message #635948] Mon, 13 April 2015 12:07 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,

We have a table in the database that is growing at rapid pace.
Is there any way we could compress the table to lessen the overall space this
massive amount of data is taking up and will continue to build up for the next 5 years?

Thanks,

Varun

Report message to a moderator

Re: compress tables [message #635949 is a reply to message #635948] Mon, 13 April 2015 12:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Yes, no, maybe. It depends.
Some, many, most IT Professionals would actually TEST on actual structure & data to learn the answer.

Report message to a moderator

Re: compress tables [message #635950 is a reply to message #635948] Mon, 13 April 2015 12:11 Go to previous message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
It really depends on licensing. In Standard Edition, Oracle provides no compression, unless you do it programmatically with utl_compress. Enterprise Edition has basic compression, which works for direct loads. Then the Advanced conpression option offers OLTP compression. If you have the appropriate release and ZFS storage, you can use Hybrid Columnar Compression.
they all have different capabilities (and drawbacks).

Report message to a moderator

Previous Topic: FRA and DATA
Next Topic: time difference between 2 oracle instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 02 17:25:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.