Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tool to dump out space info

Re: tool to dump out space info

From: Don Granaman <granaman_at_home.com>
Date: Thu, 06 Sep 2001 13:10:07 -0700
Message-ID: <F001.00385EAD.20010906131858@fatcity.com>

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">

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US