Shellスクリプトはハードディスク空間とテーブル空間の使用状況統計を実現し、メールで通知します。

#/bin/bash

#                    ，     

#       

source /home/oracle/.bash_profile

#    ip

ip=`/sbin/ifconfig eth0 | grep Bcast | cut -d : -f 2 | cut -d " " -f 1`

#        

cd /home/oracle/shell/

#              

rm -rf $ip.txt

#      

echo -e "  ！

    $ip      ：

" >> $ip.txt

echo "      ：" >> $ip.txt

/bin/df -Th >> $ip.txt

#     

echo -e "


     ：" >> $ip.txt

sqlplus -s scott/tiger << EOF >> $ip.txt

set feed off

set lines 400

set pages 900

col      for a20

select x.tablespace_name     ,  ,   ,         ,        ,      ,          ,        

  from (select TABLESPACE_NAME,round(sum(BYTES) / 1024 / 1024 / 1024, 9)    ,

               round(sum(MAXBYTES - BYTES) / 1024 / 1024 / 1024,2)         ,

               round(sum(MAXBYTES) / 1024 / 1024 / 1024)       ,

               to_char(round(sum(BYTES) / sum(MAXBYTES) * 100, 2), '990.99') || '%'           

          from dba_data_files

         group by TABLESPACE_NAME) x,

       (select a.tablespace_name,

               round(a.bytes / 1024 / 1024 / 1024, 9)   ,

               round(b.bytes / 1024 / 1024 / 1024, 9)         ,

               to_char(round(a.bytes / (a.bytes + b.bytes) * 100, 2),

                       '990.99') || '%'          

          from sys.sm\$ts_used a, sys.sm\$ts_free b

         where a.tablespace_name = b.tablespace_name) y

 where x.tablespace_name = y.tablespace_name

 order by 1;

exit

EOF

#         

mutt -s "$ip    " -- [email protected] < $ip.txt

[oracle@ ~]$ crontab -l

30 15 * * 5  /home/oracle/shell/weekcheck.sh