Re: Quick Question as I can't find the answer (Advanced Compression)
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- Date: Wed, 16 May 2018 09:39:38 -0400
On Tue, May 15, 2018 at 9:48 AM, Chris Taylor <
If we (DBAs) want to specify compression on a Partition/Subpartition,
which options are specific to Advanced Compression and which are not?
Outside of licensing, but worthy of note: BASIC is awesome until you want
to do any DML. Then you're most likely destined for non compressed row
migrations. The default PCTFREE is 0 and according to this post (which I've
never validated) states that you need to ramp it up to 90 to avoid chained
rows. So, then what is the point?
Other related posts: