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

Hi Jonathon,

What I kinda said but you say it with so much more style ;)

Cheers

Richard
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:anhluj$9r9$1$830fa795_at_news.demon.co.uk...
>
> 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
> >
> >
>
>
Received on Thu Oct 03 2002 - 20:41:33 CDT