I would like to see it also.  A few months ago, I wrote a whole space management reporting thing ("spaceman"), but it didn't (doesn't?) yet accomodate partitioning well.
 
-Don Granaman
[certifiable OraSaurus]
----- Original Message -----
From: JOE TESTA
Sent: Thursday, September 06, 2001 11:50 AM
Subject: tool to dump out space info

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
 

Reply via email to