Question: formula for calculating initial

From: Mangi <mangi1_at_hotmail.com>
Date: Mon, 06 Sep 1999 22:47:22 GMT
Message-ID: <01bef8ba$6ff3b280$f405bfce_at_default>

[Quoted] The first step (next to knowing your block size) is calculating the available space in the block for a table. The formula:

avail space in block = (db_block_size - overhead) x (PCTFREE / 100)

Question: If PCTFREE is 10 (def) then aren't we calculating the space available in the block for updates only. I thought the point was to calculate the total space available in the whole block NOT including the space saved for updates? If PCTFREE is 10 then the rest of the block is 90?

ex) (4096 - 190) x .9 = 3515 bytes / block

      (4096 - 190) x .1 = 390 bytes / block

with the first example I have 24 records / block, the second I have 2 records / block

I understand what PCTFREE is, just not how (why) we use it here.

Thanks,

Chris G    Received on Tue Sep 07 1999 - 00:47:22 CEST