Re: Does PCTFREE applies on the whole block or on the block minus block overhead ?

Unfortunately it's neither of the answers.

Apart from the general block overhead,
you also have to allow for growth of
the ITL (set initially, pre-9, by INITRANS) and then you have to allow for row index entries (2 bytes per row in the block) before working out the percentage of the row
space that will be left free.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Richard Foote wrote in message ...


>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

>

>