Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Zoetermeer, Holland

    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?

    (v9.5.5 on win2003)

  2. #2
    Join Date
    Jan 2010

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts