#####################
#dbsessioncheck.sh###
#create date:2012-05-17
#####################
#!/bin/bash
#source /oracle/.bash_profile
sqlplus -s "/as sysdba" << EOF_A
spool /oracle/count_session_values.log
set head off
set feedback off
select count(*) from v\$session;
spool off
spool /oracle/install_set_values.log
set head off
set feedback off
select value from v\$parameter where name='processes';
spool off
exit
EOF_A
for i in `cat count_session_values.log | sed '/^$/d'`;do echo $i;done > 11
for i in `cat install_set_values.log | sed '/^$/d'`;do echo $i;done > 22
if [ `cat 11` -lt `cat 22` ];then echo "db link session is normal!"
else
echo "`date +%N`|YY|31|数据库连接session数超过设定值|101|数据库连接session数超过设定值|`date +"%Y-%m-%d %H:%M:%S"`|3|当前会话数:`cat 11`设定值:`cat 22`|数据库连接session数超过设定值">>/oracle/db_status_alert.log
fi
#dbsessioncheck.sh###
#create date:2012-05-17
#####################
#!/bin/bash
#source /oracle/.bash_profile
sqlplus -s "/as sysdba" << EOF_A
spool /oracle/count_session_values.log
set head off
set feedback off
select count(*) from v\$session;
spool off
spool /oracle/install_set_values.log
set head off
set feedback off
select value from v\$parameter where name='processes';
spool off
exit
EOF_A
for i in `cat count_session_values.log | sed '/^$/d'`;do echo $i;done > 11
for i in `cat install_set_values.log | sed '/^$/d'`;do echo $i;done > 22
if [ `cat 11` -lt `cat 22` ];then echo "db link session is normal!"
else
echo "`date +%N`|YY|31|数据库连接session数超过设定值|101|数据库连接session数超过设定值|`date +"%Y-%m-%d %H:%M:%S"`|3|当前会话数:`cat 11`设定值:`cat 22`|数据库连接session数超过设定值">>/oracle/db_status_alert.log
fi
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14661773/viewspace-732700/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14661773/viewspace-732700/