Re: tool to dump out space info

I would like to see it also.  <FONT
face=Arial>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]
(<A
href="mailto:granaman_at_home.com">granaman_at_home.com) <BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: JOE TESTA To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L 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
 
Received on Thu Sep 06 2001 - 15:10:07 CDT