High Watermark Value always eludes me when calculating free space in my tablespaces.
Will the following query consider fragmented free spaces of object below the HWM value for each TS?
select * from sys.sm$ts_free;
(That would be in Oracle 10gR2)
In short, I want to know how much (the total, over and below the HWM) space does Oracle have to keep inserting things.
If my query is wrong, can someone provide one that does that?
pd. I also have other messy queries summing the segment sizes of objects, but then again, I do not know how all this wraps together with fragmented space and HWM. An explanation here would be highly appreciated.