Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does PCTFREE applies on the whole block or on the block minus block overhead ?
Hi Le JeanMimi,
The whole block.
PCTFREE gets "squeezed" at one end by rows being inserted into the block and at the other end by the header growing due to increases of the row directory and transaction slots being allocated.
In my imagination anyway.
Cheers
Richard
"Le JeanMimi" <scjm_at_noos.fr> wrote in message
news:c7be5048.0210030604.39ab6e84_at_posting.google.com...
> Say that i have :
> - a block size of 8192 bytes
> - a block overhead of 92 bytes
> - PCTFREE=20
>
> Will reserved free space for updates be ...
> 8192*0.2
> or
> (8192-92)*0.2
> ?
>
> When i read the Oracle Concepts book (8.1.7), it seems to me that it's
> the first answer but when i read some other articles i'm told it's the
> 2nd one...
>
> So ?
> TIA
Received on Thu Oct 03 2002 - 09:18:39 CDT