Home » RDBMS Server » Performance Tuning » Updating compressed rows (All with compression options)
Updating compressed rows [message #631396] Tue, 13 January 2015 08:22
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
Hi Smile

I found a damned useful entry on the impact of updating compressed data (having recently been burned by it) that I think is relatively little known so without further ado...

https://blogs.oracle.com/DBStorage/entry/updates_in_row_compressed_tables


The "tl;dr" is a bulk update of a compressed table will highly likely result in significant row chaining and space increases.

Report message to a moderator

Previous Topic: table lock in past
Next Topic: AWR - licensing question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 17 22:57:57 CDT 2018
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.