나는 삽질중이다.

#!/usr/bin/ksh
##############################################
# Subject : Automate script for system admin
#           gether nmon data monthly
# Create by : Guri / hyosuk@gmail.com
# Create date : 2006-12-22
# Modified by : Guri
# Modified date :
# Modified Contents :
#
# Scheduled Execute Date : Everymonth 1st
##############################################
PATH=/usr/bin:.
HOSTNAME=`hostname`

##################
# Previous Month #
##################
YEAR=`date +%y`
MONTH=`date +%m`

if [ $MONTH -eq 01 ]
then
    YEAR=`expr $YEAR - 1`;
    MONTH=12;
else
    MONTH=`expr $MONTH - 1`;
fi

if ((${#MONTH} < 2)) ;then
 MONTH=0$MONTH
fi

if ((${#YEAR} < 2)) ;then
 YEAR=0$YEAR
fi

TODAY=$YEAR$MONTH;

## nmon file directory
NMONDIR=/work/nmon

## target nmon file name
NMONFILE=$HOSTNAME\_$TODAY*.nmon

## move to nmon directory
cd $NMONDIR

########################################
# Send this file to NIM Server by FTP  #
########################################
HOST=10.44.155.202
USER=xxxxxxx
PASSWORD=xxxxxxxx

ftp -i -n << HERE
open $HOST
user $USER $PASSWORD
cd nmon
cd $HOSTNAME
mkdir $TODAY
cd $TODAY
mput $NMONFILE
close
bye
HERE
#

SET PAGESIZE 50
COLUMN tablespace_name FORMAT a15 HEADING "TableSPace(KB)"
COLUMN total_size_kb FORMAT 999,999,999 HEADING "Total(KB)"
COLUMN free_size_kb FORMAT 99,999,999 HEADING "Free(KB)"
COLUMN used_size_kb FORMAT 999,999,999 HEADING "Used(KB)"
COLUMN usedpercentage FORMAT 999.99 HEADING "Used %"
COLUMN files FORMAT 99999 HEADING  "Files"
COLUMN largest FORMAT 99,999,999 HEADING  "Largest"

select
T.tablespace_name,
        TS."total_size_b"/1024 as "total_size_kb",
        NVL(FS."free_size_b"/1024, 0) as "free_size_kb",
        NVL((TS."total_size_b"-FS."free_size_b")/1024, 0) as "used_size_kb",
        NVL(Round(100 * ((TS."total_size_b"-FS."free_size_b") / TS."total_size_b"), 2), 0) as "usedpercentage",
        TS."filecnt" as "files",
        FS."maxfree" as "largest"
from
        dba_tablespaces T,
        (select tablespace_name, round (sum(bytes), 0) as "total_size_b",
                count(file_name) as "filecnt"
        from dba_data_files
        group by tablespace_name) TS,
        (select tablespace_name, round(sum(bytes), 0) as "free_size_b",
                max(bytes)/1024 as "maxfree"
        from dba_free_space
        group by tablespace_name) FS
where
        T.tablespace_name = TS.tablespace_name and
        T.tablespace_name = FS.tablespace_name (+)
order by "usedpercentage" DESC;

by : DHKIM (사실 작자미상)

출처는 모르겠고, 예전회사에서 쓰던 Tablespace 사용량 확인하는 스크립트이다.