OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » compress tables (11.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

compress tables [message #635948]

Mon, 13 April 2015 12:07

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

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

John Watson
Messages: 8976
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 29 09:01:34 CDT 2025