Unanswered: Increased PCTFREE. does that affect the size of my backup image?
Did some changes on a big table:
- table partitioning,
- increased pctfree,
- new cluster index
to get better performance (especially insert performance). Now I anticipated the extra disk occupation caused by the empty blocks configured with pctfree, but now I see that the backup-image is also significant larger.
Empty blocks are not included in the backup, are they?
empty blocks are not included in the backup. But pctfree is the free space which will be left free in every block (for later inserts). So increasing pctfree also increases the size of your table and your backup.