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
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.
Re: compress tables [message #635950 is a reply to message #635948] Mon, 13 April 2015 12:11 Go to previous message
John Watson
Messages: 8922
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).
Previous Topic: FRA and DATA
Next Topic: time difference between 2 oracle instance
Goto Forum:
  


Current Time: Thu Mar 28 11:11:57 CDT 2024