oracle会话监控shell脚本
#####################
#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博客 ” ，链接：https://blog.itpub.net/23141985/viewspace-733244/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
pfile与spfile
下一篇：
恢复删除的文件
请登录后发表评论
登录
全部评论
