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
|
- Re: tool to dump out space info JOE TESTA
- Re: tool to dump out space info Rachel Carmichael
- Re: tool to dump out space info Don Granaman
- RE: tool to dump out space info Andrey Bronfin