Re: Calculating HWM(Table)

beersa wrote:

> How can measure the size of a table without calculating its high water
> marks spaces?
>
> Thanks&Cheers
>
> BEERSA
Go to Morgan's library at www.psoug.org
Click on DBMS_SPACE.

Run the demos for:

OBJECT_GROWTH_TREND_SWRF
OBJECT_SPACE_USAGE
OBJECT_SPACE_USAGE_TBF
UNUSED_SPACE
VERIFY_SHRINK_CANDIDATE
VERIFY_SHRINK_CANDIDATE_TBF

Those the one that meets your needs. (the last two will help you determine if the segment can shrink to a specific size).

-- 
Puget Sound Oracle Users Group