Amazingly, something i wrote a year ago is coming in handy now.
Here is what it does:
1. grab the total allocated, calculate free space for each
datafile.
2. grab each table and index(both partitioned and not) and calculate
the space allocated AND the space free within the extents.
3. dump all that info to CSV, so damagers can put it into spreadsheet
and do graphs(oh joy).
anyways if anyone wants it, feel free to ask and the whole thing is
yours.
its unix oriented so if you run on windoze, be sure to change / forward
slash to \ backward slash.
Unix forward thinking
windoze backward thinking,
coincidence, i think not.
joe
Received on Thu Sep 06 2001 - 11:04:51 CDT
