Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: script for table extent space used
"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 - 06:36:55 CST