It's the second one. PCTFREE and PCTUSED are calculated on the basis of the
space that's available AFTER the block header's been accounted for.
Regards
HJR
"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:59:58 CDT
