| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tool to dump out space info
me please... anything I can automate that I don't have to write is a GOOD thing :)
>From: "JOE TESTA" <JTESTA_at_longaberger.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: tool to dump out space info
>Date: Thu, 06 Sep 2001 08:50:54 -0800
>
>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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 06 2001 - 13:27:10 CDT
 |
 |