oracle监测脚本集.tar.gz

#!/bin/sh indx=0 rbs=0 system=0 users=0 tmpfile=dbtabspace.tmp hostna=`hostname` dbname=$1 if [ $hostna = "shxu0008" ] then case $dbname in tadudb) su - oracle -c "sqlplus -S '"netgain/0okm9ijn@tadudb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; calldb) su - oracle -c "sqlplus -S '"netgain/0okm9ijn@calldb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; esac fi if [ $hostna = "shxp0003" ] then su - cspdba -c "sqlplus -S '"netgain/0okm9ijn@calldb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF fi if [ $hostna = "shxp0004" ] then su - cspdba -c "sqlplus -S '"netgain/0okm9ijn@calldb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF fi if [ $hostna = "shxp0001" ] then case $dbname in tadspdb) su - tadspdba -c "sqlplus -S '"netgain/0okm9ijn@tadspdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; fmpdb) su - fmpdba -c "sqlplus -S '"netgain/0okm9ijn@fmpdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; fapdb) su - fapdba -c "sqlplus -S '"netgain/0okm9ijn@fapdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; esac fi if [ $hostna = "shxp0002" ] then case $dbname in tadspdb) su - tadspdba -c "sqlplus -S '"netgain/0okm9ijn@tadspdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; fmpdb) su - fmpdba -c "sqlplus -S '"netgain/0okm9ijn@fmpdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; fapdb) su - fapdba -c "sqlplus -S '"netgain/0okm9ijn@fapdb"'" > $tmpfile <<EOF set feedback off select t.name,100-trunc(f.free/s.total*100.0,2) from (select tablespace_name name from dba_tablespaces) t, (select tablespace_name name,sum(bytes) total from dba_data_files group by tablespace_name) s, (select tablespace_name name,sum(bytes) free from dba_free_space group by tablespace_name) f where t.name=s.name and t.name=f.name; exit EOF ;; esac fi if [ $? -eq 0 ] then error_text=`grep "ORA-" $tmpfile` if [ $? -ne 0 ] then indx=`cat $tmpfile | grep "INDX" | awk '{print $2}'` rbs=`cat $tmpfile | grep "RBS" | awk '{print $2}'` system=`cat $tmpfile | grep "SYSTEM" | awk '{print $2}'` users=`cat $tmpfile | grep "USERS" | awk '{print $2}'` temp=`cat $tmpfile | grep "TEMP" | awk '{print $2}'` else echo "error_text=$error_text" fi fi echo "Table Space Utilization (INDEX)=${indx}" echo "Table Space Utilization (RBS)=${rbs}" echo "Table Space Utilization (SYS)=${system}" echo "Table Space Utilization (USERS)=${users}" echo "Table Space Utilization (TEMP)=${temp}" echo "status_text=index:${indx}%, rbs:${rbs}%, system:${system}%, uses:${users}%, temp:${temp}%" rm $tmpfile exit 0