Re: Chunk really full??? Puzzling . . .
Cosmo Lee wrote:
>
> ODS 7.22
>
> According to my Online Administrator's Guide 7.2, pg 39-19, `oncheck
> -pt` has the same problem of not showing free space w/in extents.
>
>
> Type Pages Empty Semi-Full Full
> Very-Full
> ---------------- ---------- ---------- ---------- ----------
> ----------
> Free 45
> Bit-Map 15
> Index 0
> Data (Home) 58964
> ----------
> Total Pages 59024
>
> Unused Space Summary
>
> Unused data slots 1
> Unused bytes per data page 5
> Total unused bytes in data pages 294820
> 0 (current) 58964
Yes this is the place. The entry "Free" lists the unused pages. The
entry "Unused bytes per data page" shows wasted space on each data page.
The 45 free pages you see shows that the table has room for a few dozen
rows before needing to allocate another extent.
Art S. Kagel