Re: Blocks in DBA_TABLES and DBA_SEGMENTS

"Howard J. Rogers" wrote:
>
> Dba_segments will show the total number of blocks allocated to a segment,
> used or unused. Blocks in dba_tables shows the blocks below the High Water
> Mark (or, rather more accurately in 9i, blocks which would be read by a full
> table scan). Empty_blocks shows you the number of blocks which are above the
> high water mark (or, again, in 9i, blocks which won't be read by a full
> table scan).

Quick question since I confess I haven't had a chance to dig this deep into 9i... what's the difference in the full-table scan behavior? (You seem to imply that in 9i Oracle won't necessarily have to read every block below the HWM as it did in previous releases, unless I read you incorrectly?).

Genuinely curious,
Sean Received on Thu May 02 2002 - 18:31:26 CDT