After analyzing, the column BLOCKS are the number of BLOCKS above the HWM..
USED_BLOCKS are the blocks below the HWM. That's a quick a dirty way to
tell.
<atta707_at_my-deja.com> wrote in message news:87o7kv$qj5$1_at_nnrp1.deja.com...
> hi all the oracle gurus,
>
> i'm a newbie oracle dba.
>
> we've got a table with lotta frequent inserts and deletes. more often
> the highwater mark, and number of extents allocated for this table is
> way above what it should be.
> could you please suggest a way to find out how bad is the fragmentation
> and, more importantly, if it is the appropriate time to drop and re-
> create this table to prevent the hog.
>
> thanks in anticipation.
>
> ATTA
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 08 2000 - 19:16:19 CST
