PCTFREE & PCTUSED

From: tilwenbr_at_netscape.net <mike.borden_at_gmail.com>
Date: 5 Oct 2004 09:19:17 -0700
Message-ID: <2d4a7b11.0410050819.666c3e1c@posting.google.com>

Ok, I have a question about PCTFREE & PCTUSED.

First we are on 8.1.7.4 on VMS.

When these parameters are changed do they affect immediately? According to the concepts guide it states this: When altering the data block space usage parameters (PCTFREE and PCTUSED) of a table, note that new settings apply to all data blocks used by the table, including blocks already allocated and subsequently allocated for the table. However, the blocks already allocated for the table are not immediately reorganized when space usage parameters are altered, but as necessary after the change. The data block storage parameters are described in "Managing Space in Data Blocks".

I interpret this as that we do not have to reorganize the table for these settings to take affect on the blocks already allocated; however, they do not take immediate affect until "later" or the block reaches the new "threshold" of these settings.

Am I reading this correctly?

BTW, this is a vendor db, so we can not go to DM tablespaces yet. :(.

Mike Received on Tue Oct 05 2004 - 11:19:17 CDT