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: 1576
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.
Previous Topic: table lock in past
Next Topic: AWR - licensing question
Goto Forum:
  


Current Time: Thu Mar 28 09:15:36 CDT 2024