Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: script for table extent space used
Of course it's dynamic, and variable between blocks. Which is why I round up
all the time, and in practice add on a 'fudge factor' whatever the outcome
of the calculation (having calculated it should take 14 blocks, I said I
wouldn't get concerned if I saw it taking up 20).
You can't just pretend the header's not there, however. And you have to pick some figure. And 88 bytes is about right for a fresh block that is viewed in isolation. You know, "in theory"?
HJR
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:dSYL9.5714$jM5.15956_at_newsfeeds.bigpond.com...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:_%SL9.5485$jM5.15508_at_newsfeeds.bigpond.com...
>
> < Big Juicy Snip>
>
> > If you hope to compare the two, then don't forget to allow 88 bytes for
> the
> > block header and whatever your PCTFREE is (10, by default) which
consitute
> > unuseable space in a block.
> >
>
> Hi Howard
>
> As I'm sure you realise, the block header is dynamic and depending on the
> number of rows and number of transaction slots can vary in size from block
> to block.
>
> Cheers
>
> Richard
>
>
>
Received on Wed Dec 18 2002 - 13:10:58 CST