Re: script for table extent space used

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 18 Dec 2002 22:36:55 +1000
Message-ID: <dSYL9.5714$jM5.15956@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 - 06:36:55 CST