自己编写的简单Oracle监控脚本（二）

tbscheck.sh：
echo \ >>/data/run/sqltest/check.log
echo \ >>/data/run/sqltest/check.log
date >> /data/run/sqltest/check.log
ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=orcl;export ORACLE_SID
output=`sqlplus  internal <       @/data/run/sqltest/sqlcheck.sql
       exit
       EOF
`
num=`cat /data/run/sqltest/sql.log | sed -n '2,2p'`
if [ "$num" -gt "0" ]; then
check=`cat /data/run/sqltest/sqltest.log | sed -n '5,5p'`
echo  "tablespace:$check" >>/data/run/sqltest/check.log
else
echo  "no tablespace extent < 10" >>/data/run/sqltest/check.log
fi

sqlcheck.sql：
col tab_name new_value tab_name;
set trimspool on
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
spool /data/run/sqltest/sql.log
SELECT count(*)
  FROM sys.DBA_SEGMENTS a
 WHERE a. next_extent * 10 > (
                           SELECT MAX(b.bytes)
                             FROM DBA_FREE_SPACE b
                            WHERE a.tablespace_name = b.tablespace_name);
SELECT a.tablespace_name tab_name
  FROM sys.DBA_SEGMENTS a
 WHERE a. next_extent * 10 > (                 
                           SELECT MAX(b.bytes)
                             FROM DBA_FREE_SPACE b
                            WHERE a.tablespace_name = b.tablespace_name)
and rownum=1;
spool off;

可根据需要在脚本中添加send message功能。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/110321/viewspace-611046/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/110321/viewspace-611046/